Re: SCHEMA compatibility with Oracle/DB2/Firebird

On Sat, 22 Jan 2005 11:25:39 -0800, Chris <pglist(at)gmail(dot)com> wrote:
> I know this isn't entirely postgresql specific, but it wouldn't be on
> another list either so here goes...
>
> I am writing an open source application where I would like to support
> at least oracle, and possibly firebird or DB2, in addition to
> postgresql which will be the default. I'm not going to try to support
> mysql.

FWIW, Firebird doesn't have any form of schemas or cross-database
query support (although I think commercial third-party extensions might exist
for the latter).

You'll probably be best off explicitly providing schema names for your common
functions, e.g. SELECT * FROM common.mytable . Depending on your app,
that could be better from a security point of view in PostgreSQL as well,
if you want to prevent your users from sneakily replacing the common
database objects.

Ian Barwick