On 02/19/2011 08:03 AM, Raymond O'Donnell wrote:
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.
...and the backup user probably needs rights. Can you select from it?
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
