Обсуждение: Public Schema.

Hello all,

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
workmust be done in the client application side, I think so).. 

But I am curious about this....

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