Solar-h2o:Copper-Graphs

From Earlham CS Department
Revision as of 17:16, 21 November 2006 by Copelco (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Export database table to file

hip=# BEGIN;
BEGIN
hip=# CREATE TEMP TABLE copper_over_time AS 
hip-# SELECT to_char(date, 'MI:SS'),run1,run2,run3 FROM ss_copper_lab ORDER BY date ASC;
SELECT
hip=# COPY copper_over_time TO '/clients/users/copelco/copper_lab.txt';
COPY
hip=# ROLLBACK;
ROLLBACK