Re: pg_restore --schema always returns an empty dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nick Johnson <arachnid(at)notdot(dot)net>
Cc: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore --schema always returns an empty dump
Date: 2006-04-12 22:19:45
Message-ID: 5227.1144880385@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nick Johnson <arachnid(at)notdot(dot)net> writes:
> using "pg_restore db.dump", as expected, returns the entire dump.
> However, "pg_restore --schema foo db.dump", where 'foo' is the name of a
> schema present in the database dump always returns an empty dump.
> "pg_restore --schema foo --table bar" returns the table foo.bar, though.

> Does anyone know why this is?

Probably because it's broken :-(. I've applied a patch.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-04-12 22:41:47 IA64 RPMs for 8.1.3
Previous Message codeWarrior 2006-04-12 21:53:51 Re: Performance UPDATE/INSERT