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.
>
> thanks
>
> pete collins
CREATE TABLE foo (col-one text, col-2 text);
INSERT INTO foo SELECT * from foo1;
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
