On Fri, Aug 12, 2005 at 11:36:01PM +0800, Richard Sydney-Smith wrote:
> if a new command were available to transfer between schemas then the
> wishlist would eventually extend to ...
>
> transfer [table] [view] [rule] public.* to schema yyy;
>
> Where * would mean all entries of the selected typ
I have a database which over many years and clients has grown to about
140 tables with attendant triggers , rules and views. Having transferred
to the postgresql community from another database provider the design
did not include the use of schema.
During a recent review it struck me just how use
