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@srmsoft.co.in]
>> Sent: 09 June 2000 07:39
>> To: pgsql-general@postgresql.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.
>>
>>
>>