Postgres dblink example

Pratik Mehta <pratikmehta28@gmail.com> 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

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
<https://www.postgresql.org/docs/12/contrib-dblink-function.html&gt;, 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.klaver@aklaver.com