Re: Pass parameters to SQL script

Am Donnerstag, 19. August 2004 15:39 schrieb Fuchs Clemens:
> Now I want to concatenate a variable value with a "hardcoded" value in my
> script - something like:
>
> CREATE TABLE :myValue + _the_hardcoded_string ......

Option 1:

\set tmp :myValue 'hardcoded'
CREATE TABLE :tmp ...

Option 2:

CREATE TABLE :myValue
"hardcoded" ...

If myValue is double quoted, then the values will automatically be
concatenated by the backend parser, but for strange (SQL-standard) reasons
you need a line break in between.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/