Re: Schema Archive cant find table

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: Schema Archive cant find table
Дата
Msg-id 4D5FCDB1.6090304@iol.ie
обсуждение исходный текст
Ответ на Schema Archive cant find table  (trex005 <trex005@gmail.com>)
Ответы Re: Schema Archive cant find table  (Andy Colson <andy@squeakycode.net>)
Список 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 по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: mysql 2 pg script...
Следующее
От: Andy Colson
Дата:
Сообщение: Re: Schema Archive cant find table