[SQL] How to write query to access another odbc source
> > I have a mumps database with an ODBC connection so I can write queries from > this database. How can I write a sql in Postgresql to access this database > to use in my Postgresql reports? >
Re: [SQL] How to write query to access another odbc source
I have references to dblink. I just installed 9.1.1.1 on windows server 2008 R2 and did a search on the file dblink.sql and cannot find it. I used the one click installer from enterprisedb. 1. Where is the dblink.sql file or does it not exist anymore and the integration into postgresql has changed. 2. I cannot find any examples of connecting to another database engine through odbc. Is there any of those. On Wed, Oct 19, 2011 at 11:47 AM, Scott Marlowe wrote: > On Wed, Oct 19, 2011 at 9:19 AM, Rich wrote: > >> I have a mumps database with an ODBC connection so I can write queries > >> from this database. How can I write a sql in Postgresql to access this > >> database to use in my Postgresql reports? > > dblink lets one pg server access another via SQL, dbilink lets one pg > server access any other db server via SQL. Not sure if dbilink is > maintained or not. >
[SQL] How to write sql to access another odbc source.
I have a mumps database with an ODBC connection so I can write queries from other databases. How can I write a sql in Postgresql to access this table to use in my Postgresql reports?
Re: [SQL] postgreSQL editors
can anyone recommend a good editor for postgreSQl wich wil enable me to create functions/stored procedures? I am currently running version 7.4.1 on OS X 10.3 I use PG Manager from EMS Hitech. It is not free but inexpensive. You have everything PostgreSQL-wise at your fingertips. Ver 2.0 was just released and they are very responsive to bug reports. Rick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [SQL] Virtual records
How about a stored procedure that generates the set of records programatically. Rick Kumar wrote: Dear Friends, I am working with Postgres 7.3.4 on RH Linux. Here is a need while developing an Calendar application. I have a scheduled meeting at every month. While opening the calendar next 2 month, I need to populate the records for it. I dont want to use a temporary table and populate the records, as this will slow down the function. Is there any method for that Please shed some light. Regards Kumar ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: FW: [SQL] "=" operator vs. "IS"
My question is why is the form "(anything) = NULL" allowed? Since "(anything) = NULL" is always Null, this cannot be what the coder intended. This is much different when comparing two variables, where the coder may have to handle the cases where the variables are Null. Here the comparison is to a constant. Rick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
