Use Dblink without column defination
От | Chirag Karkera |
---|---|
Тема | Use Dblink without column defination |
Дата | |
Msg-id | CANZL2iFNWw-PtfrCsN02Sz6mKi_ooFAV2tgjNA3iAAQ2exx04Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Use Dblink without column defination
Re: Use Dblink without column defination |
Список | 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 по дате отправления: