SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 07:25 AM
| ||||
| ||||
 who can tell me the correct syntax to use dblink to talk to a table in another database I installed the dblink module, run dblink.sql to my current database to use the dblink function, but I have not been successful to select a table from a remote database (cross reference). Whoever knows how to use dblink, please show me the syntax to select another table in a remote database. Thanks a lot! Jessica --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos.      |
|
04-10-2008, 07:26 AM
| ||||
| ||||
| Re: who can tell me the correct syntax to use dblink to talkto a table in another database Jessica Richard wrote: > I installed the dblink module, run dblink.sql to my current database to > use the dblink function, but I have not been successful to select a > table from a remote database (cross reference). > > Whoever knows how to use dblink, please show me the syntax to select > another table in a remote database. Thanks a lot! See the documentation that comes with dblink, e.g.: http://developer.postgresql.org/cvsw...e=text%2Fplain HTH, Joe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
 |
« =?iso-2022-jp?B?GyRCIVYkKjZiO30kQSROPXdALSQsPCtKLCRKJHMkK0FqPGobKEI=?=
|
=?iso-2022-jp?B?GyRCIVYkMyRDJD0kajY1JCgkXiQ5IVcbKEI=?= »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:29 PM.
