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