O Andrew Sullivan έγραψε στις Nov 16, 2004 :
> On Tue, Nov 16, 2004 at 10:02:34AM +0100, Markus Schaber wrote:
> > Hello,
> >
> > Is there an easy way to move a table to another schema in PostgreSQL 7.4?
> >
> > ALTER TABLE and ALTER SCHEMA don't have this options.
>
> CREATE TABLE newschema.newtable AS SELECT * FROM oldschema.oldtable
>
> oughta work.
What about indexes, constraints, sequences,etc...???
>
> A
>
>
--
-Achilleus