Thread: Queries in another user's tables

Hello friends, I have a database base01 that belongs to user01 and on the other hand a datebase base02 that belongs to user02. I need user01 to make a query "SELECT * FROM base02.yourtable;"

How can you get this?

On 7/24/22 00:37, xavier@datolibre.com wrote:
> Hello friends, I have a database base01 that belongs to user01 and on 
> the other hand a datebase base02 that belongs to user02. I need user01 
> to make a query "SELECT * FROM base02.yourtable;"
> 
> How can you get this?
> 

In what client are you doing this?


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Thank you very much!

El 2022-07-24 04:19, Pavel Stehule escribió:

Hi

 

ne 24. 7. 2022 v 9:38 odesílatel <xavier@datolibre.com> napsal:

Hello friends, I have a database base01 that belongs to user01 and on the other hand a datebase base02 that belongs to user02. I need user01 to make a query "SELECT * FROM base02.yourtable;"

How can you get this?

 

see https://www.postgresql.org/docs/current/postgres-fdw.html

 

Regards

 

Pavel