Re: [R] Re trieving comments from PostgreSQL tables with RODBC and psqlodbc

2009-10-29 Thread Jim Cser
Upgrading the driver did not help, but you're right, I should have tried that first. Thank you for your response. Regards, Jim Cser Prof Brian Ripley wrote: > > You seriously need to update your way-obsolete software (see the > posting guide), but you are seeing what your ODBC driver is retu

Re: [R] Re trieving comments from PostgreSQL tables with RODBC and psqlodbc

2009-10-29 Thread Prof Brian Ripley
You seriously need to update your way-obsolete software (see the posting guide), but you are seeing what your ODBC driver is returning, not an R issue. R-sig-db is a better list for help on database connectivity. On Wed, 28 Oct 2009, Jim Cser wrote: I don't know whether this is an RODBC iss

[R] Re trieving comments from PostgreSQL tables with RODBC and psqlodbc

2009-10-29 Thread Jim Cser
I don't know whether this is an RODBC issue, a psqlodbc issue or a PostgreSQL issue; I've searched the documentation and forums for each, with no success. I want to list all the tables in a PostgreSQL schema, and return the table comments as well as the table names. As an example, one table is d