Moving a PostgreSQL database from one server to another

Anthony E. Greene tony at greene-family.org
Mon Jan 24 20:37:23 UTC 2005


On 20:37 Jan 24, 2005 "Rodolfo J. Paiz" <rpaiz at simpaticus.com> 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.


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

--Tony





More information about the fedora-list mailing list