Re: Pass parameters to SQL script
От | Fuchs Clemens |
---|---|
Тема | Re: Pass parameters to SQL script |
Дата | |
Msg-id | 9DDD01E6B277D511B22300A0C9EEE776025D522C@LNZP106A обсуждение исходный текст |
Ответ на | Pass parameters to SQL script (Fuchs Clemens <clemens.fuchs@siemens.com>) |
Ответы |
Re: Pass parameters to SQL script
|
Список | pgsql-general |
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,
Clemens
-----Ursprüngliche Nachricht-----
Von: Daniel Martini [mailto:dmartini@uni-hohenheim.de]
Gesendet: Donnerstag, 19. August 2004 12:00
An: Fuchs Clemens
Cc: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Pass parameters to SQL script
Hi,
Citing Fuchs Clemens <clemens.fuchs@siemens.com>:
> 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 .
> CREATE TABLE &1..test (name VARCHAR2(100));
>
> Is there a counterpart for PostgreSQL?
call psql like this to set a variable named your_variable_name to my_table:
psql -v your_variable_name=my_table
to expand the variable your_variable_name to its value (my_table in this case)
in the sql script, precede its name with a colon, like so:
select * from :your_variable_name;
which will expand to:
select * from my_table;
the psql manpage has more info on all this.
Regards,
Daniel
В списке pgsql-general по дате отправления: