On Mon, 23 Jun 2003, L.V.Boldareva wrote:
> Hello!
>
> many people posted their answer to this simple question. however,
> neither
> CREATE TABLE AS
> nor
> SELECT INTO
>
> do not take care about keys and triggers, etc.
>
> The commands above only copy the structure of the table, and the data.
Hello!
many people posted their answer to this simple question. however,
neither
CREATE TABLE AS
nor
SELECT INTO
do not take care about keys and triggers, etc.
The commands above only copy the structure of the table, and the data.
Are there any workarounds fr copying the table as a whole object?
Hi,
Le Mardi 17 Juin 2003 20:46, Achilleus Mantzios a écrit :
> On 17 Jun 2003, Rado Petrik wrote:
> > How I create table1 from other table2 .
> >
> > "cp table1 table2"
>
> create table table2 as select * from table1;
>
Another way would be:
select * into table2 from table1;
(See
http://www.p
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
---(end of br
etrik
> Envoyé : mardi 17 juin 2003 17:21
> À : [EMAIL PROTECTED]
> Objet : [SQL] CREATE table1 FROM table2
>
>
> Hi,
>
> How I create table1 from other table2 .
>
> "cp table1 table2"
>
> Thanks.
>
> --
> Rado Petrik <
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
Dynaco
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
[EMAIL PROTECTED] [EMAIL PROTECTED]
http://www.tdmsoft.com
Hi,
How I create table1 from other table2 .
"cp table1 table2"
Thanks.
--
Rado Petrik <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
