import data from csv to postgresql

sudo -u postgres psql 
 
Postgresql to csv file:-  
 
COPY products TO '/home/products.csv' DELIMITER ',' CSV HEADER;


CSV to Postgresql table:-  
 
COPY products FROM '/home/products.csv' DELIMITER ',' CSV HEADER;
 
products is table name. 

Comments

Popular Posts

How to pass hash in Postman

nginx: unrecognized service

Reading Excel Sheets using "Roo" gem in ruby on rails

Bootstrap Select Picker append add new item if search not exist

Add CORS to Nginx on AWS Elastic Beanstalk

Enable gzip compression on Elastic Beanstalk with nginx

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Get video duration by URL in Ruby on Rails

site-enables nginx setting in ruby in rails