Re: Moving a PostgreSQL database from one server to another

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux