Csv into data postgres

COPY table_name FROM 'C:\Users\Public\Documents\ert.txt' DELIMITER ',' CSV
-- make sure to put the file in public folder in windows 
-- Or temp folder in linux/mac 
-- because it might ask for some permissions...

Postgresql import data from csv

copy table from '/home/usama/Documents/columns_rearrange.csv' csv header ;

Similar codes

1 vote223 views1 answer
Sometimes i cant edit sql developer
SQL
22 votes212 views3 answers
Sql cheat sheet
SQL
0 vote209 views1 answer
Mysql jdbc timezone
SQL
0 vote222 views1 answer
Sql shell psql cannot enter password
SQL
18 votes210 views2 answers
Sql inner join
SQL
0 vote234 views1 answer
How to find sql server installation folder
SQL
15 votes231 views5 answers
Show tables in oracle
SQL
11 votes223 views2 answers
Having in sql
SQL
0 vote214 views1 answer
Syntax for changing column size in mysql
SQL
1 vote242 views1 answer
Drop primary key oracle
SQL