RE: to pass a parameter

From: Michael Ansley <Michael(dot)Ansley(at)intecsystems(dot)co(dot)uk>
To: "'jprem'" <jprem(at)srmsoft(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org
Subject: RE: to pass a parameter
Date: 2000-06-09 08:38:49
Message-ID: 2D50E16224C8D311B183009027452B476AFC97@INTEC003
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

>> -----Original Message-----
>> From: jprem [mailto:jprem(at)srmsoft(dot)co(dot)in]
>> Sent: 09 June 2000 07:39
>> To: pgsql-general(at)postgresql(dot)org
>> Subject: [GENERAL] 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.
>>
>>
>>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jprem 2000-06-09 10:00:09 help on macro substitution
Previous Message jprem 2000-06-09 06:38:54 to pass a parameter