Re: Queries in another user's tables (SOLVED)

From: xavier(at)datolibre(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Queries in another user's tables (SOLVED)
Date: 2022-07-24 16:50:02
Message-ID: 5b3be8427eb880c17dd923238259b537@datolibre.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you very much!

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

> Hi
>
> ne 24. 7. 2022 v 9:38 odesílatel <xavier(at)datolibre(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Kalcher 2022-07-24 19:29:39 Re: [PATCH] Introduce array_shuffle() and array_sample()
Previous Message Adrian Klaver 2022-07-24 16:29:06 Re: Queries in another user's tables