Difference between revisions of "Solar-h2o:Copper-Graphs"

From Earlham CS Department
Jump to navigation Jump to search
(No difference)

Revision as of 18:16, 21 November 2006

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