| 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: | Whole Thread | Raw Message | 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 |