List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 14 1999 1:55pm
Subject:Re: creating tables from other tables
View as plain text  
pete collins wrote:
> This doesnt seem to be legal syntax:
> CREATE TABLE foo (col-one text, col-2 text)
> 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 (home) (work)
creating tables from other tablespete collins14 Jun
  • Re: creating tables from other tablesSasha Pachev15 Jun