EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Oracle Compatibility - tables and columns in quotes  XML

Forum Index » Advanced Server
Author Message
[Post New]3 Feb 2012 00:57:12
    Subject: Oracle Compatibility - tables and columns in quotes
[Up]
Timv256

New member

Joined: 3 Feb 2012 00:49:33
Messages: 1
Offline
In Oracle the table "TABLENAME" is the same as TABLENAME without the quotes, so in some of our application select statements the table name is referenced with quotes and other cases without quotes because in Oracle, they are the same. So when I run a query on Postgres Advanced Server in Oracle Compatibility mode referencing TABLENAME, it is different than "TABLENAME". I am trying out Postgres Advanced Server to see if it will work for us and this is the major problem that I have encountered. Is there an easy way around this behavior? Is there a parameter to change it to work like Oracle? The same thing happens with column names.

Thanks in advance for any suggestions.

This message was edited 2 times. Last update was at 3 Feb 2012 01:02:50
[Post New]7 Feb 2012 14:28:40
    Subject: Re:Oracle Compatibility - tables and columns in quotes
[Up]
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 452
Offline
Yes.

"TABLENAME" and TABLENAME is different. "TABLENAME" means you want to make table name case sensitive.

Oracle keeps object name in capital letter by default and Advanced Server keeps object name in small letters by default.

You would like to remove those double quotes from application.
Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
 
Forum Index » Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team