Re: CREATE table1 FROM table2

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Rado Petrik <r(dot)p(at)szm(dot)sk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: CREATE table1 FROM table2
Date: 2003-06-17 15:35:54
Message-ID: 3EEF355A.9000503@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia 2003-06-17 17:20, Użytkownik Rado Petrik napisał:
> Hi,
>
> How I create table1 from other table2 .
>
> "cp table1 table2"
create table2 as select * from table1;
It is described in Postgresql documentation SQL Commands -> "create table as"

Regards,
Tomasz Myrta

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael A Nachbaur 2003-06-17 15:57:26 Object-Relational table design question
Previous Message Nicolas JOUANIN 2003-06-17 15:34:05 Re: CREATE table1 FROM table2