PostgreSQL superuser does not access other databases

Question

So basically I have 2 superusers, postgres and eric, each with their own databases. What I want to do is, while being connected to one of them, access the database (tables to be more precise) of the other. The tables of both databases are in public schema.

I am using this query, which I found on another question on the forum, but without any result:

SELECT table_name
FROM information_schema.tables
WHERE table_schema='public'

I have changed the owners of the databases, offered all the privileges to both roles, but nothing. All I get are only the tables of the database under that user, not both.

Any idea what I could be missing? Thanks.

P.S: I am using PostgreSQL 9.3, and coding in Python 2.7

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

Superusers can always access everything in the whole cluster.

This sentence makes no sense:

Both databases are in public schema.

Cluster -> database -> schema -> table. Start with the manual here.

While connected to a particular database you can only access tables of this particular database. You have to connect to a different database to work with tables there.
Or you can use dblink or FDW.

edited May 23 '17 at 10:32

Community

1
1

answered Jun 21 '14 at 18:05

Erwin Brandstetter

605,456
145
1,078
1,228

I was referring to the tables in the databases, sorry. I've edited it now. I know that they should access the whole cluster... but it's not happening... and I don't know why... – user3475502 Jun 22 '14 at 07:31
@user3475502: I added some more. – Erwin Brandstetter Jun 22 '14 at 10:13

score -1 · Answer 2 · answered Jun 21 '14 at 23:10

-1

PostgreSQL has a firewall between different databases. They might as well be on totally separate servers. You can use dblink or fdw or something like those to bridge between them.

answered Jun 21 '14 at 23:10

jjanes

37,812
5
27
34

PostgreSQL superuser does not access other databases

2 Answers2