Copy table from postgres to local

Question

I want to copy table from postgis database to the PC hard drive (format can be .txt .xls .csv or whatever). How it can be done?

Erwin Brandstetter · Accepted Answer · 2012-03-09 01:31:06Z

1

Use the SQL COPY command to write to the file system of the database server.

COPY tbl TO '/path/to/file/tbl.sql';

There are lots of options to adapt the output format.

Have a look at the \copy meta-command of psql if you need to copy from a remote server to the local disk.

answered Mar 9, 2012 at 1:31

668k159 gold badges1.2k silver badges1.3k bronze badges

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

1 Answer 1