On Jan 4, 2008 11:51 AM, Afewtips.com <afewtips@xxxxxxxxx> wrote: > > I do read mentions about dblink connections, but how to install it > > looks unclear and complicated. > > small clarification here. dblink is for connecting two postgresql databases together. It is, IMO, neither unclear nor complicated :-). dbilink, (note the 'I'), which aiui uses perl dbi in a dblink style interface...never used it personally. for moving data in and out of sql server and postgresql, you have a number of options, odbc, dbi, php, etc etc. in the end, you have to query a, process the result and send the answer to b. csv format is great for data transfers in and out of postgres. for example, you can pull data out of something in csv, load it into a postgresql scratch table with the copy statement, and run queries there to get it into the final destination table. merlin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
