Thread: Exporting data as SQL

Exporting data as SQL

From
Søren Neigaard
Date:
Is it possible to dump the data from a PostgreSQL database, without any
information about setting up tables and users, just the data? And how is it
done?

Med venlig hilsen/Best regards
Søren Neigaard
System Architect
................................
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 5.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: s.neigaard@mobilethink.dk
Web: www.mobilethink.dk
................................


Re: Exporting data as SQL

From
Martijn van Oosterhout
Date:
On Wed, Jan 08, 2003 at 01:21:24PM +0100, Søren Neigaard wrote:
> Is it possible to dump the data from a PostgreSQL database, without any
> information about setting up tables and users, just the data? And how is it
> done?

pg_dump -a

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.

Attachment