Re: pg_restore vs psql - Mailing list pgsql-admin

From Victor Yegorov
Subject Re: pg_restore vs psql
Date
Msg-id 20030426130955.GC8194@pirmabanka.lv
Whole thread Raw
In response to pg_restore vs psql  (Erwin Ambrosch <naus.office@aon.at>)
List pgsql-admin
* Erwin Ambrosch <naus.office@aon.at> [26.04.2003 15:53]:
> Hi,
>
> can one tell me whether there are main differences in using
> pg_restore of "psql -f mydb.dump mydb" on a file created with pg_dump.

psql understands only plain SQL commands. pg_dump can create custom format
dumps, gzipped dumps and tarballs along with SQL dumps.

You cannot feed, say, custom dump to psql.

--

Victor Yegorov

Attachment

pgsql-admin by date:

Previous
From: Erwin Ambrosch
Date:
Subject: pg_restore vs psql
Next
From: "Nick Fankhauser"
Date:
Subject: Re: pg_restore vs psql