Re: Variables in SQL scripts - Mailing list pgsql-general

From Tim Landscheidt
Subject Re: Variables in SQL scripts
Date
Msg-id m3r5kfcfi6.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to Variables in SQL scripts  ("Machiel Richards" <machielr@rdc.co.za>)
List 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 by date:

Previous
From: Thom Brown
Date:
Subject: Where has ms2pg gone?
Next
From: Craig Ringer
Date:
Subject: Linux kernel OOM killer rewrite