Solar-h2o:Copper-Graphs: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| 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 23: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=#