Thread: 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