| From: | juerg(dot)rietmann(at)pup(dot)ch |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dump from within a sql statement |
| Date: | 2002-10-23 13:40:01 |
| Message-ID: | OF441888BB.4A1D3442-ONC1256C5B.004AB378-C1256C5B.004B2D14@pup.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
__________________________________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gareth Kirwan | 2002-10-23 17:13:15 | Quickie Part3 - same as part1 |
| Previous Message | Ian Barwick | 2002-10-23 13:38:36 | Re: Print line? |