Re: CREATE table1 FROM table2 - Mailing list pgsql-sql

Hi,

Le Mardi 17 Juin 2003 20:46, Achilleus Mantzios a écrit :
> On 17 Jun 2003, Rado Petrik wrote:
> > How I create table1 from other table2 .
> >
> > "cp table1 table2"
>
> create table table2 as select * from table1;
>
Another way would be: select * into table2 from table1;

(See
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-selectinto.html).


--
Guillaume <!-- http://absfr.tuxfamily.org/ -->.