On Thursday, February 20, 2003, at 02:23 PM, Tariq Muhammad wrote:
> select * from pg_namespace ;
> Fist get the oid of the schema that you want to get the table list for
> :
> select oid from pg_namespace where nspname = 'schema_name';
> select relname from pg_class where relnamespace = oid; ## above oid.
> update pg_namespace set nspname='new_schema_name' where
> nspname='schema_name';
You've got to be kidding ;-)
Seriously though, isn't the purpose of schemas to make organization of
tables more convenient? It seems like dealing with schemas is a big
hassle. It'd be nice to have something like "\d", except for schemas,
to list the schemas that you've created, and an "alter schema"
statement to modify them.
--Dan
