| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Archana K N <archanakknn(at)gmail(dot)com>, itb348(at)gmail(dot)com, guillaume(at)lelarge(dot)info, PostgreSQLPHP PostgreSQLPHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: How to Create a table in another database |
| Date: | 2015-11-13 11:54:41 |
| Message-ID: | 5645CF81.9020601@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
On 13/11/2015 05:35, Archana K N wrote:
> Here the underlined queries are for /db2. /I need to create function
> in the second database since first database contain data that is not for
> public access. So from second database I call the *db1.retriev *and it
> uses necessary data from *db1 *and result is saved as a table in second
> database. Actual function has more parameters and result may contain
> many rows , for that I want to create table in */db2/*.
Have you considered using two separate schemas within the same database?
You can set permissions on them so that one is for public access and the
other isn't; it would be far easier than messing with two databases.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias Ritzkowski | 2015-11-13 12:16:05 | Re: How to Create a table in another database |
| Previous Message | Archana K N | 2015-11-13 05:35:38 | Re: How to Create a table in another database |