agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: michael@sqlexec.com <michael@sqlexec.com>
To: Eugene Yin <eugeneymail@ymail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: public synonym
Date: Thu, 07 Jan 2016 15:27:13 -0500
Message-ID: <568ECA21.20702@sqlexec.com> (raw)
In-Reply-To: <358282890.1765953.1452197860946.JavaMail.yahoo@mail.yahoo.com>
References: <358282890.1765953.1452197860946.JavaMail.yahoo.ref@mail.yahoo.com>
<358282890.1765953.1452197860946.JavaMail.yahoo@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
You can infer the context by first setting the search_path variable.
You can set it initially in your connection or do it for a database
context or even a role context
SET search_path = MASTER_USER, public, pg_catalog;
ALTER DATABASE whatever SET search_path = MASTER_USER, public, pg_catalog;
ALTER ROLE whoever SET search_path = MASTER_USER, public, pg_catalog;
Then you can continue to let the tables be non-qualified. bye bye
synonyms!
Regards
Michael
> Eugene Yin <mailto:eugeneymail@ymail.com>
> Thursday, January 7, 2016 3:17 PM
> PostgreSQL ver 9.4.5. Linux OS.
> Application: Web Based
>
> Platform:
> App Server (java) --> jdbc call --> Database Server (PostgreSQL)
>
>
> I do know that PostgreSQL does not support the public synonym.Now, for
> a user schema (let's call it MASTER_USER), if I coded in the stored
> function/procedure like the following, without using a public synonym
> to identify the table name:
>
> select user_name from user_info_table
>
> then access it from the Java (web app) sidevia the JDBC call to the
> database, will that work?
>
> OR,
>
> I must use the identifier inside the sql, such as:
>
> select user_name fromMASTER_USER.user_info_table?
>
>
> I come from the Oracle world, there I first create the public synonym
> for the table, then in the stored procedure I just directly reference
> the table with no need to identify the table with a schema name. Like
> to know how it work under the PostgreSQL.
>
>
> Thanks
>
> Eugene
view thread (3+ messages) latest in thread
Message-ID: <568ECA21.20702@sqlexec.com>
Permalink: ../568ECA21.20702@sqlexec.com/
Also on: postgresql.org/message-id/568ECA21.20702@sqlexec.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: michael@sqlexec.com, eugeneymail@ymail.com
Subject: Re: public synonym
In-Reply-To: <568ECA21.20702@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox