to pass a parameter
hello,
how can i pass a table name dynamically to a query ?
in oracle we do
select * from &x
how is it here ?
please help.
I'm under the impression that this substitution is performed by SQLPlus
(somebody please correct me otherwise). Hence, it's not the database server
that needs to do this, but the client (i.e. shell, or psql). This should be
achievable using shell script, and psql.
MikeA
Show quoted text
-----Original Message-----
From: jprem [mailto:jprem@srmsoft.co.in]
Sent: 09 June 2000 07:39
To: pgsql-general@postgresql.org
Subject: [GENERAL] to pass a parameterhello,
how can i pass a table name dynamically to a query ?in oracle we do
select * from &xhow is it here ?
please help.
Import Notes
Resolved by subject fallback
Michael Ansley wrote:
I'm under the impression that this substitution is performed by
SQLPlus (somebody please correct me otherwise).
it's true ! It's only available for SQLPlus.
I'm a beginner with postgres, but i saw in the User's documentation that
we can create a SQL function to pass parameter
(i copy/paste)
Parameters
A parameter is used to indicate a parameter in a SQL function. Typically
this is used in SQL function definition statement. The
form of a parameter is:
$number
For example, consider the definition of a function, dept, as
CREATE FUNCTION dept (name)
RETURNS dept
AS 'select * from
dept where name=$1'
LANGUAGE 'sql';
(i guess there's something more simple)
Nicolas
Hence, it's not the
Show quoted text
database server that needs to do this, but the client (i.e. shell, or
psql). This should be achievable using shell script, and psql.MikeA
-----Original Message-----
From: jprem [mailto:jprem@srmsoft.co.in]
Sent: 09 June 2000 07:39
To: pgsql-general@postgresql.org
Subject: [GENERAL] to pass a parameterhello,
how can i pass a table name dynamically to a query ?in oracle we do
select * from &xhow is it here ?
please help.
Sorry, but i made a mistake here !
the function dept or is equivalente coud not solve this problem (pass a
table name as a parameter)
In Oracle exist Dynamic SQL, is there something like that in postgres ?
Is it possible to execute a query built in a plpgsql function or do we
need to use Perl and the Pg module for exemple ?
Nicolas.
NRonayette wrote:
Show quoted text
(i copy/paste)
ParametersA parameter is used to indicate a parameter in a SQL function. Typically
this is used in SQL function definition statement. The
form of a parameter is:$number
For example, consider the definition of a function, dept, as
CREATE FUNCTION dept (name)
RETURNS dept
AS 'select * from
dept where name=$1'
LANGUAGE 'sql';(i guess there's something more simple)
Nicolas
-----Original Message-----
From: jprem [mailto:jprem@srmsoft.co.in]
Sent: 09 June 2000 07:39
To: pgsql-general@postgresql.org
Subject: [GENERAL] to pass a parameterhello,
how can i pass a table name dynamically to a query ?in oracle we do
select * from &xhow is it here ?
please help.