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-13 16:40:46
Message-ID: 200203131640.g2DGekVc005645@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2002-03-13 16:42:26 Re: missing greatbridge / database session monitor
Previous Message Greg Sabino Mullane 2002-03-13 16:40:41 Re: Storing Credit Card Info?