Thread: Export a database or a table from a database

Hello,

I want to export a database or a table from a database.
There is a possibility the copy the data from the table, but
I need the whole structure include the data.

Regards
Stefan

Read the documentation, in particular look for 'pg_dump'.

Lee.

Stefan Kowalski writes:
 > I want to export a database or a table from a database.
 > There is a possibility the copy the data from the table, but
 > I need the whole structure include the data.

"Stefan Kowalski" <Stefan.Kowalski@ixtra.com> writes:

> I want to export a database or a table from a database.
> There is a possibility the copy the data from the table, but
> I need the whole structure include the data.

'pg_dump' should do what you want.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

> I want to export a database or a table from a database.
> There is a possibility the copy the data from the table, but
> I need the whole structure include the data.

pg_dump -u database_name --table tablename > file.sql