Обсуждение: pg_dump from within a sql statement

Поиск
Список
Период
Сортировка

pg_dump from within a sql statement

От
juerg.rietmann@pup.ch
Дата:
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
__________________________________________________