Re: Renaming schema's - Mailing list pgsql-general

From Tom Lane
Subject Re: Renaming schema's
Date
Msg-id 3247.1038789243@sss.pgh.pa.us
Whole thread Raw
In response to Renaming schema's  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
Responses Re: Renaming schema's  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List pgsql-general
Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
> I have tried to rename a schema using:
> test=# update pg_catalog.pg_namespace
> test-#     set nspname = 'jochemd'
> test-#     where nspname = 'public';

> This didn't work out very well, the schema became invisible in
> pgAdminII, something I wouldn't want to do to our customers.

I would expect that to work; perhaps the problem is pgAdminII's?

            regards, tom lane

pgsql-general by date:

Previous
From: Nic Ferrier
Date:
Subject: elisp for managing functions
Next
From: Jochem van Dieten
Date:
Subject: Re: Renaming schema's