On 10/31/2017 12:41 AM, John R Pierce wrote:
if you're doing a lot of this, why not use two schema in the same
database? then its just ...schema.table...
otherwise, you need to use FDW and foreign tables.
see
https://www.postgresql.org/docs/current/static/postgres-fdw.html
oh, I sh
On 10/31/2017 12:15 AM, Sherman Willden wrote:
I am trying to access a table from another database. I have the
permissions to create under my own login. I have performed the
following so far:
sherman@sql-dev: createdb sandbox01
sherman@sql-dev:~$ createdb sandbox02.
After logging into sandbox02
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sherman Willden
Sent: Tuesday, October 31, 2017 9:15 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to access a second database
I am trying to access a table from another database. I have the permissions to
create
I am trying to access a table from another database. I have the permissions
to create under my own login. I have performed the following so far:
sherman@sql-dev: createdb sandbox01
sherman@sql-dev:~$ createdb sandbox02.
After logging into sandbox02 I performed the following: sandbox02=# CREATE
TABL
