On 23.05.22 10:16, Chirag Karkera wrote:
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.
Not in dblink. You could use foreign-data wrappers, which have a different interface, which you might like better.
