From: | zmokdad(at)vanrise(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14433: Bulk insert |
Date: | 2016-11-25 07:15:28 |
Message-ID: | 20161125071528.6534.58612@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14433
Logged by: zeinab mokdad
Email address: zmokdad(at)vanrise(dot)com
PostgreSQL version: 9.6.1
Operating system: Windows
Description:
using Npgsql 3.1,
I am unable to do a bulk insert of a text file in postgres server.
I am using below to insert object by object.
using (NpgsqlConnection conn = new
NpgsqlConnection(GetConnectionString()))
{
if (conn.State == ConnectionState.Closed) conn.Open();
using (var inStream =
conn.BeginTextImport(string.Format("COPY {0} FROM STDIN", tableName)))
{ inStream.Write(route);
}
}
is there anyway where I can insert the list of object at one hit?
From | Date | Subject | |
---|---|---|---|
Next Message | phb07 | 2016-11-25 15:14:48 | BUG #14434: Drop a table with a serial in an extension |
Previous Message | Michael Paquier | 2016-11-25 02:23:14 | Re: Index file got removed |