Postgres Pro
Downloads
Home   >   mailing lists

Re: Export a database or a table from a database - Mailing list pgsql-general

From Jean-Michel POURE
Subject Re: Export a database or a table from a database
Date
Msg-id 200203061300.g26D02Lx007126@www1.translationforge
Whole thread Raw
In response to Export a database or a table from a database  ("Stefan Kowalski" <Stefan.Kowalski@ixtra.com>)
List pgsql-general
Tree view 
Le Mercredi 6 Mars 2002 12:43, Stefan Kowalski a écrit :
> 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.

all data : pg_dump -u  > file_name.sql
only a table : pg_dump -u --table=TABLE_NAME > file_name.sql
For a complete list of pg_dump options, pg_dump --help

/JMP

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Export a database or a table from a database
Next
From: Eric Webber
Date:
Subject: Looking for an ODBC driver for postgres