Re: pg_restore vs psql

From: "Victor Yegorov" <viy(at)pirmabanka(dot)lv>
To: Erwin Ambrosch <naus(dot)office(at)aon(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore vs psql
Date: 2003-04-26 13:09:55
Message-ID: 20030426130955.GC8194@pirmabanka.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Erwin Ambrosch <naus(dot)office(at)aon(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2003-04-26 21:24:48 Re: pg_restore vs psql
Previous Message Erwin Ambrosch 2003-04-26 12:48:19 pg_restore vs psql