new idea for COPY and MOVE

From: ivan <iv(at)psycho(dot)pl>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: new idea for COPY and MOVE
Date: 2003-07-22 20:51:29
Message-ID: Pine.LNX.4.56.0307222244350.4593@rex.anfa.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


hi
what do you tink about :
COPY [ namespace1. ] table [ STRUCT ONLY ] TO [namespace2.] table2;
MOVE [ namepsace1. ] table TO [namespace2.] table2;

and this same whit types, functions etc

and :

ALERT FUNCTION func (ARGS) SET OWNER new_owner;

and :

CREATE TYPE new_type AS table;

this can by replaced by LIKE : CREATE TYPE new_type AS ( LIKE table )
what i saw in one mail on this maillist

can be ?

bye
iv

Browse pgsql-hackers by date

  From Date Subject
Next Message Nigel J. Andrews 2003-07-22 20:56:15 Re: Why select * from function doesn't work when function
Previous Message Francisco Figueiredo Jr. 2003-07-22 20:47:01 Re: Why select * from function doesn't work when function