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/