Re: Public Schema. - Mailing list pgsql-general

From Joe Conway
Subject Re: Public Schema.
Date
Msg-id 3DEBC945.1030806@joeconway.com
Whole thread Raw
In response to Public Schema.  (Terry Yapt <pgsql@technovell.com>)
List pgsql-general
Terry Yapt wrote:
> after migrate from 7.2.x to 7.3, I have noticed about all tables, views,
> etc.. are in the PUBLIC schema.
>
> ok...
>
> Are there any way to change quickly all objects from PUBLIC schema to a
> user-schema ?  (of course, after that a lot of work must be done in the
> client application side, I think so)..

There is presently no easy way once the objects have been created. You might
want to edit the dump file from 7.2.x before loading into 7.3.

Joe


pgsql-general by date:

Previous
From: Medi Montaseri
Date:
Subject: Re: vacuum full analyze problem
Next
From: Medi Montaseri
Date:
Subject: Re: Segmentation fault while COPY in 7.3