pete collins wrote:
> This doesnt seem to be legal syntax:
> CREATE TABLE foo (col-one text, col-2 text)
> AS (SELECT * FROM fooOLD);
> I am trying to restructure a table.
> If I do the above,
> is there a way to dump say:
> SELECT id FROM foo > /home/myhome/fooDUMP;
> or would i have to use something like script.
> pete collins
CREATE TABLE foo (col-one text, col-2 text);
INSERT INTO foo SELECT * from foo1;