importing data from csv file in remote machine to postgresql table

Question

How can i use copy command for bulk insertion of data into postgresql table from csv file present in remote machine using C#? I've a front end in C# using which i need to load data into postgresql table from csv file. The database is in remote server and the csv file is in my machine.

Craig Ringer · Accepted Answer · 2014-01-30 01:21:24Z

1

Assuming the CSV file is on the machine running the C# program, you need to use COPY ... FROM STDIN. This is difficult to use directly from client drivers, but most of them support their own interfaces on top.

I'm guessing you are using nPgSQL since you didn't bother to mention what client you're using. If so, you can use NpgsqlCopyIn.

answered Jan 30, 2014 at 1:21

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bruno · Accepted Answer · 2014-01-29 18:14:35Z

0

Not possible at all, unless you mount the remote machine on the postgres server. To copy postgres needs to be able to access the file locally.

You could try to scp the file from A to B, or parse the file yourself and do bulk inserts into postgres, ie: create table file (structure of the file); Read 100 lines insert into tabe file values (line 1) ,(line 2) ... ,line (100)

answered Jan 29, 2014 at 18:14

Bruno

6414 silver badges6 bronze badges

1 Comment

Craig Ringer Over a year ago

Nonsense, COPY ... FROM STDIN is for exactly this purpose.

Collectives™ on Stack Overflow

importing data from csv file in remote machine to postgresql table

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related