Re: CREATE table1 FROM table2

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
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:31:52
Message-ID: Pine.LNX.4.44.0306171831230.20339-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

On 17 Jun 2003, Rado Petrik wrote:

> How I create table1 from other table2 .

CREATE TABLE table1 AS SELECT * FROM table2;

will work.

Regards,
--
Devrim GUNDUZ
devrim(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)tr
http://www.tdmsoft.com
http://www.gunduz.org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Mascari 2003-06-17 15:32:31 Re: Request for advice: Table design
Previous Message Rado Petrik 2003-06-17 15:20:46 CREATE table1 FROM table2