actually just wanted to give an update in my search to find a solution for the pass through queries problem.
http://support.microsoft.com/kb/q131534/ is basicly what I'm looking for but it's for SQL Server. Does anyone know if there is a function simular to sp_server_info" in postgres?
Ben
Hi, thanks for your reply. Sorry but it seems you mis interpreted the question. It's a nice bit of code through, which I learnt in Object-Orientated Programming in Java.
I'd try and be more specific with what my problem is, feel free to ask any questions if you want to. :)
I've just done my...
Hi,
I would like to create a procedure so that I can run a select query. What I would like to return is all the fields so that obviously means I got to make a new type which all the properties of the fields.
Can anyone tell me how to do this?
what do you need done?
I recently imported CSV files myself. What I did was to create a script to import the CSV's and saved it as a txt file. Then you simply type in psql dbname -f script.txt into command prompt.
Really handy, as I found in my case postgres didnt like fields that had dates...
Hi,
I am in the process of migrating from an MS Access 2000 DB backend to a PostgreSQL backend. Currently the frontend is MS Access, and I would like to keep using Access as the frontend.
My question is, that once you use the link table wizzard to obtain all the data in the PostgreSQL backend...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.