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 [, ...] ]