Re: Schema Archive cant find table

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