Use Dblink without column defination

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