Re: Variables in SQL scripts

Поиск
Список
Период
Сортировка
От Tim Landscheidt
Тема Re: Variables in SQL scripts
Дата
Msg-id m3r5kfcfi6.fsf@passepartout.tim-landscheidt.de
обсуждение исходный текст
Ответ на Variables in SQL scripts  ("Machiel Richards" <machielr@rdc.co.za>)
Список pgsql-general
"Machiel Richards" <machielr@rdc.co.za> wrote:

> [...]
>               I did some googling as well and found something I tested using
> a simple method:

> -          I created an sql script to set the variable Name DB

> o   \set DB <dbname>

> o   \c :DB

> -          I connected to postgresql using the postgres database and ran the
> sql script which seemed to work fine as it then connected me to the
> database.

> However will this method work with the above situation as well or are there
> other ways of doing this?
> [...]

Why don't you try it?

Tim

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Where has ms2pg gone?
Следующее
От: Craig Ringer
Дата:
Сообщение: Linux kernel OOM killer rewrite