On Thu, Jul 05, 2001 at 08:33:04AM -0700, R Vijayanath wrote:
> It would be great if you can tell me if I can write a
> procedure that can write the output to the OS(Linux
> OS) file.
Yes, you can do it :-).
> Can you assist me on this if there is a way to do it.
Try the pg_dump utility, which writes out database to SQL code that may be
used to re-create it on the same or another system. Here is the example
section from the manual page:
EXAMPLES
To dump a database:
$ pg_dump mydb > db.out
To reload this database:
$ psql -d database -f db.out
To dump a database called mydb that contains BLOBs to a
tar file:
$ pg_dump -Ft -b mydb > db.tar
To reload this database (with BLOBs) to an existing
database called newdb:
$ pg_restore -d newdb db.tar
--
Henry House
OpenPGP key available from http://romana.hajhouse.org/hajhouse.asc