BUG #14433: Bulk insert

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?

Browse pgsql-bugs by date

  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