Use Dblink without column defination - Mailing list pgsql-hackers

From Chirag Karkera
Subject Use Dblink without column defination
Date
Msg-id CANZL2iFNWw-PtfrCsN02Sz6mKi_ooFAV2tgjNA3iAAQ2exx04Q@mail.gmail.com
Whole thread Raw
Responses Re: Use Dblink without column defination
Re: Use Dblink without column defination
List pgsql-hackers
Hi Team, 

Appreciate your time to look into this. 

To select from another database I try to use dblink or fdw extension of Postgres, like this:

mesods =>CREATE EXTENSION dblink;

CREATE EXTENSION

mesods => CREATE EXTENSION postgres_fdw;

CREATE EXTENSION

mesods=> select dblink_connect('conn_db_link','foreign_server') ;

 dblink_connect

----------------

 OK

(1 row)

 

mesods=> select * from dblink('foreign_server','select * from ods_sch.emp') AS x(a int,b text);

 a |    b

---+---------

 1 | Gohan

 1 | Piccolo

 1 | Tien

(3 rows)


This works fine when I specify which columns I want to select. 


Is there something that postgres has without specifying the column names we can fetch the data from dblink. 


Awaiting your reply.


Thank you.


Regards,

Chirag Karkera

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql now shows zero elapsed time after an error
Next
From: Peter Eisentraut
Date:
Subject: Re: PG15 beta1 fix pg_database view document