[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Queries in another user's tables (SOLVED)
From:       xavier () datolibre ! com
Date:       2022-07-24 16:50:02
Message-ID: 5b3be8427eb880c17dd923238259b537 () datolibre ! com
[Download RAW message or body]

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
[Attachment #3 (unknown)]

<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" \
/></head><body style='font-size: 12pt; font-family: Verdana,Geneva,sans-serif'> \
<p>Thank you very much!</p> <div id="signature">&nbsp;</div>
<p><br /></p>
<p id="reply-intro">El 2022-07-24 04:19, Pavel Stehule escribi&oacute;:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; \
margin: 0"> <div id="replybody1">
<div dir="ltr">Hi
<div dir="ltr">&nbsp;</div>
<br />
<div class="v1gmail_quote">
<div class="v1gmail_attr" dir="ltr">ne 24. 7. 2022 v&nbsp;9:38 odes&iacute;latel \
&lt;<a href="mailto:xavier@datolibre.com" \
rel="noreferrer">xavier@datolibre.com</a>&gt; napsal:</div> <blockquote \
class="v1gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid \
#cccccc; padding-left: 1ex;"> <div style="font-size: 12pt; font-family: \
Verdana,Geneva,sans-serif;"> <p>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;"</p> <p>How can you get \
this?</p> </div>
</blockquote>
<div>&nbsp;</div>
<div>see <a href="https://www.postgresql.org/docs/current/postgres-fdw.html" \
target="_blank" rel="noopener \
noreferrer">https://www.postgresql.org/docs/current/postgres-fdw.html</a></div> \
<div>&nbsp;</div> <div>Regards</div>
<div>&nbsp;</div>
<div>Pavel</div>
</div>
</div>
</div>
</blockquote>
</body></html>



[prev in list] [next in list] [prev in thread] [next in thread]

Configure | About | News | Add a list | Sponsored by KoreLogic