Re: Public Schema.

From: Joe Conway <mail(at)joeconway(dot)com>
To: Terry Yapt <pgsql(at)technovell(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Public Schema.
Date: 2002-12-02 20:57:41
Message-ID: 3DEBC945.1030806@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2002-12-02 21:01:03 Re: Arrays: determining size
Previous Message Medi Montaseri 2002-12-02 20:53:55 Re: vacuum full analyze problem