Re: Use Dblink without column defination

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.