Difference between revisions of "Solar-h2o:Copper-Graphs"
Jump to navigation
Jump to search
(→Export database table to file) |
|||
| Line 1: | Line 1: | ||
=== Export database table to file === | === Export database table to file === | ||
| − | hip=# BEGIN; | + | 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; | |
| − | hip=# CREATE TEMP TABLE | ||
| − | |||
SELECT | SELECT | ||
| − | hip=# COPY | + | hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt';COPY |
| − | + | hip=# ROLLBACK;ROLLBACK | |
| − | hip=# ROLLBACK; | + | hip=# |
| − | |||
Revision as of 19:22, 21 November 2006
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=#
