Excluding tables from pg_restore

From: Carlos <Carlos(at)pbsinet(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Excluding tables from pg_restore
Date: 2003-06-16 16:45:55
Message-ID: E148BE531B8AD311922E005004D3EEA101D511D9@xchserver.pbsinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi forum,

How can I exclude a few tables from a pg_dump and a pg_restore? I have a
pg_dump of a database with several hundred tables and I want to restore most
of these tables into another database hence I want to exclude a couple of
the tables from the restore. In the man pages, I found the -t option for
pg_restore but I would have to name several hundreds tables to use this.

Thanks in advance for your response

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-06-16 16:49:44 Re: full featured alter table?
Previous Message Rory Campbell-Lange 2003-06-16 16:43:54 Can I do <page> of <pages> in one call?