Re: psql "SCHEMA" switch

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: psql "SCHEMA" switch
Дата
Msg-id 73998921-2665-4F19-B94D-08083B19EFD3@seespotcode.net
обсуждение исходный текст
Ответ на psql "SCHEMA" switch  (Paul Silveira <plabrh1@gmail.com>)
Ответы Re: psql "SCHEMA" switch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Dec 22, 2006, at 15:15 , Paul Silveira wrote:

> I wanted to connect to a DB and then insert that new DDL into a
> "specific"
> schema.  Because psql does not have a schema switch, I had to do it
> this
> way...

As the schema is part of the DDL, I think it's better to have it as
part of DDL script rather than a switch for psql, either as schema-
qualified tables in the script or using a SET search_path command in
the SQL script.

Michael Glaesemann
grzm seespotcode net



В списке pgsql-general по дате отправления:

Предыдущее
От: Paul Silveira
Дата:
Сообщение: psql "SCHEMA" switch
Следующее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Re: xml2 install problem