//连接postgre数据库
var connString = "Host=192.168.144.128;Port=5432;Username=user;Password=user;Database=test";
DataTable pgdt = new DataTable();
String sqrstr = "select * from public.testtable ";
using (var conn = new NpgsqlConnection(connString))
{
try
{
conn.Open();
// Retrieve all rows
using (NpgsqlDataAdapter sqldap = new NpgsqlDataAdapter(sqrstr, conn))
{
sqldap.Fill(pgdt);
}
DateTime start = DateTime.Now;
FileStream fs = File.OpenRead(@"d:\data.cvs");
NpgsqlCommand command = new NpgsqlCommand("COPY public.testtable(id,name) FROM STDIN DELIMITER ';' ", conn);
NpgsqlCopyIn cin = new NpgsqlCopyIn(command, conn, fs);
cin.Start();
cin.End();
DateTime end = DateTime.Now;
}
catch(NpgsqlException ex)
{
MessageBox.Show(ex.Message);
}
}
if(pgdt.Rows.Count > 0)
{
MessageBox.Show("sdff");
}
sqrstr = "COPY public.testtable(id,name) from 'data.cvs' delimiter ';' csv HEADER";