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.