Re: can we write to a flat file from Postgresql procedure - Mailing list pgsql-novice

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