Hi,
Citing Fuchs Clemens [EMAIL PROTECTED]:
is it possible to pass parameters to a SQL script, which I launch via the
psql shell?
yes
In Oracle it works like that:
sqlplus myscript.sql myschema
and within the script I can use the parameter like this:
CONCAT .
Title: AW: [GENERAL] Pass parameters to SQL script
thanks for tip - I'm nearly happy now.
Now I want to concatenate a variable value with a hardcoded value in my script - something like:
CREATE TABLE :myValue + _the_hardcoded_string ..
Is this possible?
thanks
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
Peter Eisentraut [EMAIL PROTECTED] writes:
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.
That works for literals (single-quotes), but I don't think it applies
to