BUG #14433: Bulk insert

Started by Nonameover 9 years ago1 messagesbugs
Jump to latest
#1Noname
zmokdad@vanrise.com

The following bug has been logged on the website:

Bug reference: 14433
Logged by: zeinab mokdad
Email address: zmokdad@vanrise.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?

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs