On 18/02/2011 15:40, trex005 wrote:
I am trying to archive a schema, however there is a certain table that gets skipped with pd_dump The table's name is 'servers'. I checked to see if it is a reserved word, and it does not appear to be... Thinking I was missing something I tried using -t servers, and I get : pg_dump: No matching tables were found
Do you mean schema as in the table definitions etc, or schema as in a particular logical division in the DB?
If the latter, you probably have to specify the schema name: pg_dump -t my_schema.servers .... Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
