Re: Export a database or a table from a database

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: "Stefan Kowalski" <Stefan(dot)Kowalski(at)ixtra(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Export a database or a table from a database
Date: 2002-03-06 13:00:02
Message-ID: 200203061300.g26D02Lx007126@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Webber 2002-03-06 13:01:29 Looking for an ODBC driver for postgres
Previous Message Oliver Elphick 2002-03-06 12:49:04 Re: Export a database or a table from a database