Displaying 1 result from an estimated 1 matches for "ezone_locationprice_year1".
2009 Oct 29
1
Re trieving comments from PostgreSQL tables with RODBC and psqlodbc
..., 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
follows:
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)
)
WITHOUT OIDS;
ALTER TABLE scen990.ezone_locationprice_...