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)
> 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)
Thread
creating tables from other tablespete collins14 Jun
  • Re: creating tables from other tablesSasha Pachev15 Jun