RE: to pass a parameter

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.
>>   
>>   
>>