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

Jim Cser jim.cser at oregonmetro.gov
Thu Oct 29 02:44:35 CET 2009

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 defined as

CREATE TABLE scen990.ezone_locationprice_year1
  ezone integer NOT NULL,
  lprice_man_year1 real,
  lprice_war_year1 real,
  lprice_ret_year1 real,
  lprice_gen_year1 real,
  lprice_med_year1 real,
  lprice_gov_year1 real,
  CONSTRAINT ezone_locationprice_year1_pkey PRIMARY KEY (ezone)
ALTER TABLE scen990.ezone_locationprice_year1 OWNER TO mscope;
COMMENT ON TABLE scen990.ezone_locationprice_year1 IS 'calculated';

The RODBC function sqlTables() returns all the tables, but the records look
like this:

mscope     scen990     ezone_locationprice_year1     TABLE     ""

All the "REMARKS" values are empty strings.  Can I get it to return the
COMMENT ON values instead?  (the table_owner and tablet_qualifier are
switched but that doesn't worry me)   I'm using  R 2.8.1, RODBC 1.2-4,
psqlodbc 8.0.2, and PostgreSQL 8.1.5 .  

Jim Cser
View this message in context: http://www.nabble.com/Retrieving-comments-from-PostgreSQL-tables-with-RODBC-and-psqlodbc-tp26104999p26104999.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list