On Thu, Dec 15, 2011 at 11:09 AM, Raymond O'Donnell <rod@xxxxxx> wrote: > The point here is that with the plain-text dump (the default output from > pg_dump), you can feed that directly to psql; but you have no control > over what is restored, or in what order, without editing the dump file > directly. > > If, however, you using one of the other output options, you need to use > pg_restore; but you can do all sorts of things with the restore. I think I now understand and sorry. I have not been using PostgreSQL long at all and it's my first ever venture into any RDBMS and even ANSI SQL. So basically: pg_dump = plain text dumps which can be read by 'psql' & 'pg_restore'. pg_dump -Fc = custom / compressed dumps that must be used by pg_restore only with options to pick / choose what I want from the dump. I hope I got that right. I think I've learned a lot from you guys pointing me in the right direction and RTFM. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
