Displaying 1 result from an estimated 1 matches for "lprice_gen_year1".
2009 Oct 29
1
Re trieving comments from PostgreSQL tables with RODBC and psqlodbc
...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_year1 OWNER TO mscope;
COMMENT ON TABLE scen990.ezone_locationprice_year1 IS 'calculated';
The RODBC function sql...