Re: CREATE table1 FROM table2

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
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 20:46:32
Message-ID: Pine.LNX.4.44.0306171845010.26046-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 17 Jun 2003, Rado Petrik wrote:

> Hi,
>
> How I create table1 from other table2 .
>
> "cp table1 table2"

create table table2 as select * from table1;

>
> Thanks.
>
>

--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill at matrix dot gatewaynet dot com
mantzios at softlab dot ece dot ntua dot gr

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-06-17 23:18:35 Re: Blobs with perl
Previous Message Jonathan Gardner 2003-06-17 20:37:37 Re: Can the frontend get notifications from the postgres server?