Re: can we write to a flat file from Postgresql procedure

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