Flownet.Data.Postgres
0.1.1
dotnet add package Flownet.Data.Postgres --version 0.1.1
NuGet\Install-Package Flownet.Data.Postgres -Version 0.1.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Flownet.Data.Postgres" Version="0.1.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Flownet.Data.Postgres" Version="0.1.1" />
<PackageReference Include="Flownet.Data.Postgres" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Flownet.Data.Postgres --version 0.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Flownet.Data.Postgres, 0.1.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Flownet.Data.Postgres@0.1.1
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Flownet.Data.Postgres&version=0.1.1
#tool nuget:?package=Flownet.Data.Postgres&version=0.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Flownet.Data.Postgres
PostgreSQL data actions for the Flownet pipeline library.
Actions
- PostgresQLExecute - Execute SQL commands against PostgreSQL via Dapper
- SqlServerToPostgresBulkCopy - Stream data from SQL Server to PostgreSQL via Npgsql binary import
SqlServerToPostgresBulkCopy
High-performance bulk data transfer using Npgsql's binary COPY protocol. Features:
- Two-layer type resolution - CLR type inference with destination schema tiebreaker
- Auto-mapping - matches source/destination columns by name
- Batched commits - configurable batch size with progress logging
- Generated column exclusion - automatically skips computed columns
var builder = new PipelineBuilder(logger);
await builder
.StartWith<SqlServerToPostgresBulkCopy>(op =>
{
op.SourceConnectionString = "Server=.;Database=MyDb;...";
op.SourceQuery = "SELECT * FROM dbo.MyTable";
op.DestinationConnectionString = "Host=localhost;Database=mydb;...";
op.DestinationTable = "public.mytable";
op.BatchSize = 100000;
op.NotifyAfter = 500000;
})
.ExecuteAsync();
Installation
dotnet add package Flownet.Data.Postgres
Requires Flownet (referenced automatically). Target: net8.0 only.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net8.0
- Flownet (>= 0.1.1)
- Npgsql (>= 9.0.3)
- System.Data.SqlClient (>= 4.8.6)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.