Re: Postgres dblink example

2021-10-29 Thread Adrian Klaver 

On 10/29/21 07:02, Pratik Mehta wrote:

Hi Postgres Community,

I am an Oracle DBA with 12 years experience. The example in Postgres 
dblink_connect page seems incomplete. We find it difficult to 
understand. How can I get access to more examples ?


Also, in dblink page 
https://www.postgresql.org/docs/12/contrib-dblink-function.html 
, can 
we get example on how to create connname and connstr?


See:
https://www.postgresql.org/docs/current/contrib-dblink-connect.html



--
Regards,
Pratik Mehta
+91 9664022206



--
Adrian Klaver
adrian.kla...@aklaver.com

Re: Postgres dblink example

2021-10-29 Thread Tom Lane 
Pratik Mehta  writes:
> I am an Oracle DBA with 12 years experience. The example in Postgres
> dblink_connect page seems incomplete. We find it difficult to understand.
> How can I get access to more examples ?

If you're really confused, you could look at the module's regression
tests:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=contrib/dblink/sql/dblink.sql;h=7a71817d65b97fc549b4b54f531e6692f8273d58;hb=HEAD
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=contrib/dblink/expected/dblink.out;h=91cbd744a996020c44a3e98fa1c7fd224008ef98;hb=HEAD

regards, tom lane