Re: programatic database dump

Tomi NA wrote:
> I'd like to dump a postgresql database from my (java) app and copy the
> dump file to the client machine.
> This backup strategy prooved invalueable in the past (given enough
> room on the harddrives, which I have) and I'd like to implement it now
> with postgresql.
> Is there something like a system stored procedure that does something
> like that I can use? Calling pg_dump seems like a bad hack: I'd like
> to keep communication at the java<->sql level if possible. I'll
> probably bare it, but I'd like to check if I've missed something, first.
>
> TIA,
> Tomislav
might help...
test=# \h copy
Command: COPY
Description: copy data between a file and a table
Syntax:
COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE NOT NULL column [, ...] ]

COPY tablename [ ( column [, ...] ) ]
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE QUOTE column [, ...] ]