FW: Creating database links
От | Ferrell, Denise CTR NSWCDD, Z11 |
---|---|
Тема | FW: Creating database links |
Дата | |
Msg-id | 2BC18916DE4BF141AC1EFC55CE2CAE7D5817E5@NAEANRFKXM01V.nadsusea.nads.navy.mil обсуждение исходный текст |
Ответ на | Creating database links ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>) |
Ответы |
Re: FW: Creating database links
(Stephen Frost <sfrost@snowman.net>)
|
Список | pgsql-admin |
Hi Jorge, What would be the syntax for extracting all columns from a database table using dblink? Could this be used if you are unsureof the structure of the table you're extracting from? Thank you in advance, d -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jorge Fernandez Sent: Thursday, May 22, 2014 11:22 AM To: Tom Lane Cc: Ferrell, Denise CTR NSWCDD, Z11; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Creating database links This is what we're using , don't forget to install db_link module select * from dblink('host=1192.168.1.1 dbname=mydb port=5432 user=myuser password=my_password', 'select name from country')as t1 (proname name, prosrc text); Best Regards... 2014-05-22 12:10 GMT-03:00 Tom Lane <tgl@sss.pgh.pa.us>: "Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil> writes: > I've looked thru the documentation and I can't find where PostgreSQL allows for database links (something similarto what's available in Oracle). Closest thing we've got is foreign tables based on the postgres_fdw foreign data wrapper (or you could use a different wrapper if you want to link to a non-Postgres database). regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jorge Daniel Fernandez Leader - DBA Team S: elgaita99 | t:@openenglish w: www.openenglish.com <http://www.openenglish.com/> <http://www.openenglish.com/> Opensoft Argentina S.R.L 552 Suipacha , Piso 3to, Capital Federal Argentina, (C1022AAR) (*) The content of this electronic message may be privileged and confidential. (*) If you are not an intended recipient of this email, please delete it and do not use it. (*) The Open English name and the Open English logo are registered trademarks. (*) Opensoft Argentina S.R.L is a vendor company of Open English LLC. <http://www.openenglish.com/> -- Jorge Daniel Fernandez Leader - DBA Team S: elgaita99 | t:@openenglish w: www.openenglish.com <http://www.openenglish.com/> <http://www.openenglish.com/> Opensoft Argentina S.R.L 552 Suipacha , Piso 3to, Capital Federal Argentina, (C1022AAR) (*) The content of this electronic message may be privileged and confidential. (*) If you are not an intended recipient of this email, please delete it and do not use it. (*) The Open English name and the Open English logo are registered trademarks. (*) Opensoft Argentina S.R.L is a vendor company of Open English LLC. <http://www.openenglish.com/>
Вложения
В списке pgsql-admin по дате отправления: