PostgreSQL 2018(2)Dump the Data to CSV

magic_dreamer

于 2018-05-05 23:09:16 发布

阅读量175

点赞数

CC 4.0 BY-SA版权

分类专栏： Database 文章标签：数据库

本文链接：https://blog.csdn.net/magic_dreamer/article/details/84920101

Database 专栏收录该内容

53 篇文章

订阅专栏

PostgreSQL 2018(2)Dump the Data to CSV

My data is pretty simple
>select * from usertable;
name signupdate
sillycat 2018-05-03

This Dump command will dump all the data to one csv file
>
copy (select name as "Name", signupdate as "SignupDate" from usertable) to '/Users/hluo/temp/user.csv' WITH (FORMAT CSV, HEADER, DELIMITER ',', ENCODING 'UTF8', FORCE_QUOTE *);

If my user can not do the copy command, we need to change the user to superuser with this command
>
alter user postgres superuser;

The Tool I use is SQLpro for Postgres

References:
http://sillycat.iteye.com/blog/2421981