Re: Schema Archive cant find table

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: trex005 <trex005(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema Archive cant find table
Date: 2011-02-19 14:03:29
Message-ID: 4D5FCDB1.6090304@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2011-02-19 14:06:34 Re: Schema Archive cant find table
Previous Message Andy Colson 2011-02-19 13:49:22 Re: mysql 2 pg script...