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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general