Re: SCHEMA compatibility with Oracle/DB2/Firebird

From: Nicolai Tufar <ntufar(at)gmail(dot)com>
To: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
Cc: Chris <pglist(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SCHEMA compatibility with Oracle/DB2/Firebird
Date: 2005-01-25 09:29:45
Message-ID: d809293905012501291a361f4d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 23 Jan 2005 12:09:26 -0600, Jeffrey Melloy
<jmelloy(at)visualdistortion(dot)org> wrote:
> Although Oracle doesn't have a search path, it is possible to make
> functions publicly available by doing "grant blah to public". After
> that they can be used without a schema identifier.

There is also
CREATE PUBLIC SINONYM thing in Oracle.

> Jeff
Nicolai

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2005-01-25 09:40:15 Extended unit
Previous Message Martijn van Oosterhout 2005-01-25 08:23:31 Re: Object Relational, Foreign Keys and Triggers