db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Duddikunta, Padmanabha" <P...@cdc.gov>
Subject Schema qualifier for table names
Date Mon, 16 Jun 2003 16:21:30 GMT
I having trouble specifying schema qualifier for tables.  I login to
database using a user "dbuser", but my tables lie under a different schema

say XYZ schema.

 

Now I want to query XYZ.TABLE1.  But torque seems to generate sql something
like,

 

SELECT COL1, COL2, COL3 FROM dbuser.TABLE1   instead of

 

SELECT COL1, COL2, COL3 FROM XYZ.TABLE1

 

 

I would appreciate any pointer on solving this problem.

 

Thanks

Paddy

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message