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 type As of 8.1 there is a new ALTER TABLE variation which lets you move tables and views from one schema to another. There's also an ALTER FUNCTION and a couple of other I forget. http://developer.postgresql.org/docs/postgres/sql-altertable.html http://developer.postgresql.org/docs/postgres/sql-alterfunction.html Note however that they do not accept wildcards. In fact, we do not support wildcards at all in SQL (except for LIKE expressions, etc) AFAIR. -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "Si quieres ser creativo, aprende el arte de perder el tiempo" ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
