Solar-h2o:Copper-Graphs

From Earlham CS Department
Revision as of 18:22, 21 November 2006 by Copelco (talk | contribs) (Export database table to file)
Jump to navigation Jump to search

Export database table to file

hip=# BEGIN;BEGIN
hip=# CREATE TEMP TABLE copper_runs AShip-# SELECT to_char(run3,'099.99') as run3,to_char(run2,'099.99') as run2,to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
SELECT
hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt';COPY
hip=# ROLLBACK;ROLLBACK
hip=#