Postgres Pro
Downloads
Home   >   mailing lists

Re: moving database objects from one schema to other - Mailing list pgsql-general

From Pavel Stehule
Subject Re: moving database objects from one schema to other
Date
Msg-id AANLkTim0q1XGQOrzetpf9aDpEs+HWEVa_k7GkNS9t7q_@mail.gmail.com
Whole thread Raw
In response to moving database objects from one schema to other  (akp geek <akpgeek@gmail.com>)
Responses Re: moving database objects from one schema to other  (akp geek <akpgeek@gmail.com>)
List pgsql-general
Tree view 
2010/10/28 akp geek <akpgeek@gmail.com>:
> Hi all -
>               I would like to know if there is any other way of moving
> objects from one schema to other schema? right now the way I am doing it is
> , take the backup and importing whatever the database objects I wanted to
> move, I am doing that using pg_restore. But I am finding it difficult for
> functions, sequences
> Thanks for your help
> Regards

hello

use a statement: ALTER TABLE tablename SET SCHEMA new_schema

Regards

Pavel Stehule

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: moving database objects from one schema to other
Next
From: Szymon Guz
Date:
Subject: Re: PostGIS return multiple points