Moving a PostgreSQL database from one server to another

Anthony E. Greene tony at
Mon Jan 24 20:37:23 UTC 2005

On 20:37 Jan 24, 2005 "Rodolfo J. Paiz" <rpaiz at> wrote:
>Is there a simple way, other than pg_dump,
>to dump all the output of a single *table* to STDOUT?

  =>copy tablename to stdout

If you could start psql as the postgres user, you could specify a filename
as the output device.

For a large table, you could specify HTML output then open the resulting
HTML table in a spreadsheet for further processing.

  =>\o bigtable.html
  =>select * from bigtable;


More information about the users mailing list