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