On 28/01/2009 17:09, David Miller wrote:
> Pg Dump does not include schema name on insert statement generated
> from pg_dump with a -d option when exporting data for a particular
> table using the -t <schema>.<table> in version 8.3. I believe this
> same bug exists in 8.4 but have not confirmed it. I believe pg_dump
> should have an option to retain schema information.
From memory, I think it does include a "set search_path" statement near
the beginning.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------