how to export and import data in POSTGRES

[nguyenb9]

I would like to know how to import and export data into POSTGRES database.

How do I load .CSV data to postgres.

Thank you for your help in this matter.

 

[stoolpigeon]

You can use copy to import data

http://techdocs.postgresql.org/techdocs/usingcopy.php

the above will take you to a nice tutorial on using copy effectively and has many links to official docs etc. on using copy.