Date: Fri, 14 Oct 2005 11:39:47 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: copy table
Message-ID: <20051014093947.GJ10299@webserv.wug-glas.de>
Mail-Followup-To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>,
	pgsql-sql@postgresql.org
References: <004801c5d09b$747fad80$1102a8c0@dream>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <004801c5d09b$747fad80$1102a8c0@dream>
User-Agent: mutt-ng 1.5.9i (Linux)

am  14.10.2005, um 10:44:13 +0200 mailte Shavonne Marietta Wijesinghe folgendes:
> Hello
> 
> How can i copy a table from one schema to another..

create table as select * from table

> 
> Example..

Yeah!

test=# create schema foo;
CREATE SCHEMA
test=# create schema bar;
CREATE SCHEMA
test=# create table foo.test (id int);
CREATE TABLE
test=# insert into foo.test values (1);
INSERT 3381544 1
test=# create table bar.test as select * from foo.test;
SELECT
test=# select * from foo.test;
 id
----
  1
(1 row)

test=# select * from bar.test;
 id
----
  1
(1 row)


> I use pgadmin 3 to make my database in postgresql

You shold better use psql to learn sql.


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===