pg_dump from within a sql statement - Mailing list pgsql-admin

From juerg.rietmann@pup.ch
Subject pg_dump from within a sql statement
Date
Msg-id OF441888BB.4A1D3442-ONC1256C5B.004AB378-C1256C5B.004B2D14@pup.ch
Whole thread Raw
List pgsql-admin
Hello there

Is it possible to use a pg_dump like command from within a sql statement
and write the data/schema to an ascii file on the harddisc ?
I have a scheduler running and it writes log messages about db actions
 into a log db.

When i need to run pg_dump with cron I don't see these messages in the log.

thanks ... jr
__________________________________________________

PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

internet          :  www.pup.ch
phone       : +4141 790 4040
fax         : +4141 790 2545
mobile            : +4179 211 0315
__________________________________________________



pgsql-admin by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Print line?
Next
From: "Gareth Kirwan"
Date:
Subject: Quickie Part3 - same as part1