sql_copy [beOpen

new ordered table

CREATE TABLE <newtable> AS SELECT * FROM <sourcetable> order by <field1>,<field2>;
ALTER TABLE <newtable> RENAME TO <newname>;

CREATE TEMP TABLE rescomo AS
    SELECT * FROM residenti WHERE provincia = 13 AND res2001 > 1500;
COPY rescomo TO '/home/luca/tmp/rescomo.csv';