Re: Schema Archive cant find table - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Schema Archive cant find table
Date
Msg-id 4D5FCDB1.6090304@iol.ie
Whole thread Raw
In response to Schema Archive cant find table  (trex005 <trex005@gmail.com>)
Responses Re: Schema Archive cant find table  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
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@iol.ie

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: mysql 2 pg script...
Next
From: Andy Colson
Date:
Subject: Re: Schema Archive cant find table