If you explicitly name your schemas (including public) in all of your SQL it will port easily to Oracle.
Chris
<[EMAIL PROTECTED]> To: Tom Lane
<[EMAIL PROTECTED]>
Sent by: cc:
[email protected]
[EMAIL PROTECTED] Subject: Re: [GENERAL] SCHEMA
compatibility with Oracle/DB2/Firebird
tgresql.org
01/22/2005 05:05 PM
Please respond to Chris
>
> AFAIK the idea of a schema search path is specific to PG. I'm not sure
> how you will handle your "public" functions in other DBMSes.
>
> regards, tom lane
>
I'll probably have to go research this for each database. I have no
plans on immediately supporting other databases, but I don't want to
use a structure that will be extremely difficult to port down the
road.
Chris
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
