| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | rod(at)iol(dot)ie |
| Cc: | trex005 <trex005(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Schema Archive cant find table |
| Date: | 2011-02-19 14:06:34 |
| Message-ID: | 4D5FCE6A.1000205@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2011-02-19 14:50:08 | Re: mysql 2 pg script... |
| Previous Message | Raymond O'Donnell | 2011-02-19 14:03:29 | Re: Schema Archive cant find table |