Mike Christensen <mike@xxxxxxxxxxxxx> writes: >> Is the TAR format just the raw SQL commands, just tar'ed and then sent >> over the wire? Sorta. If you pull it apart with tar, you'll find out there's a SQL script that creates the database schema, and then a separate tar-member file containing the data for each table. Custom format goes this a little better by splitting the information up into a separate archive item for each database object. But there's no tool other than pg_restore that knows how to deconstruct custom-format archives. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
