Re: Queries in another user's tables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: xavier(at)datolibre(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Queries in another user's tables
Date: 2022-07-24 09:19:10
Message-ID: CAFj8pRAE82w1jvfZYz4b7oarjoXOJttj845Au29hwdWNyC9n_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2022-07-24 15:29:53 Re: Strange behavior between timestamp and date comparison
Previous Message Fabien COELHO 2022-07-24 08:15:22 Re: [PATCH] Introduce array_shuffle() and array_sample()