Re: Schema Archive cant find table

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