On Sat, Oct 25, 2008 at 5:32 PM, Bryce Nesbitt <[EMAIL PROTECTED]> wrote: > Dear Postgres Gurus; > > Is there a way to truncate a table, at pg_dump time? > > I'm aware of various ways to exclude a table from a dump (>= 8.2), or to > selectively pg_restore. What I'm seeking here is different. I've got > tables with pretty disposable data... meaning I want to drop the data... > but restore empty indexed tables at pg_restore time.
Do a schema-only dump. pg_dump --help says use '-s' or '--schema-only'. -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
