pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Devrim GUNDUZ <devrim@gunduz.org>
To: Rado Petrik <r.p@szm.sk>
Cc: pgsql-sql@postgresql.org
Subject: Re: CREATE table1 FROM table2
Date: Tue, 17 Jun 2003 18:31:52 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0306171831230.20339-100000@emo.org.tr> (raw)
In-Reply-To: <1055863245.624.1.camel@caj>


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@gunduz.org				devrim.gunduz@linux.org.tr 
			http://www.tdmsoft.com
			http://www.gunduz.org




view thread (8+ messages)  latest in thread

Message-ID: <Pine.LNX.4.44.0306171831230.20339-100000@emo.org.tr>
Permalink:  ../Pine.LNX.4.44.0306171831230.20339-100000@emo.org.tr/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0306171831230.20339-100000@emo.org.tr

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: devrim@gunduz.org, r.p@szm.sk
  Subject: Re: CREATE table1 FROM table2
  In-Reply-To: <Pine.LNX.4.44.0306171831230.20339-100000@emo.org.tr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox