import data from csv file in Postgres

Question

ERROR:  could not open file "C:\Program Files\PostgreSQL\10\data\Data_copy\student.csv" for reading: No such file or directory
HINT:  COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
SQL state: 58P01

You really should consider adding an explanation about what you are trying to do, also post any code you have, and what you have tried so far. — Hoppo
– Hoppo, Commented Jun 12, 2020 at 10:05

pifor · Accepted Answer · 2020-06-12 07:52:01Z

2

The error message says it all.

If you use SQL COPY command the file to be loaded must be accessible on database server side.

If this is not possible you can use psql CLI \copy command from the client side because it can access a file on client side.

Example:

$ cat t.csv
1,ONE
2,TWO
3,THREE

In psql:

# \d t
                     Table "public.t"
 Column |  Type   | Collation | Nullable | Default 
--------+---------+-----------+----------+---------
 x      | integer |           |          | 
 y      | text    |           |          | 


# \copy t from 't.csv' delimiter ',';
COPY 3

# select * from t;
 x |   y   
---+-------
 1 | ONE
 2 | TWO
 3 | THREE
(3 rows)

edited Jun 12, 2020 at 7:52

answered Jun 12, 2020 at 7:22

pifor

7,9722 gold badges11 silver badges18 bronze badges

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

1 Comment

Mridul-Acharya Over a year ago

Can you suggest an example?

Wize · Accepted Answer · 2020-06-12 07:51:17Z

0

Using psql run the following command

\copy students from 'C:\Program Files\PostgreSQL\10\data\Data_copy\student.csv' csv;

answered Jun 12, 2020 at 7:51

Wize

1,10010 silver badges20 bronze badges

Collectives™ on Stack Overflow

import data from csv file in Postgres

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related