Friday, 15 May 2015

PostgreSQL superuser does not access other databases -



PostgreSQL superuser does not access other databases -

so have 2 superusers, postgres , eric, each own databases. want is, while beingness connected 1 of them, access database (tables more precise) of other. tables of both databases in public schema.

i using query, found on question on forum, without result:

select table_name information_schema.tables table_schema='public'

i have changed owners of databases, offered privileges both roles, nothing. tables of database under user, not both.

any thought missing? thanks.

p.s: using postgresql 9.3, , coding in python 2.7

superusers can access in whole cluster.

this sentence makes no sense:

both databases in public schema.

cluster -> database -> schema -> table. start manual here.

while connected particular database can access tables of particular database. have connect different database work tables there. or can utilize dblink or fdw.

database postgresql python-2.7 root

No comments:

Post a Comment