Hi, a while back I saw a thread about how to list schemas. The solution presented was:
Select * FROM pg_namespace
That's great except the results include non schema data and no real way (that I can tell) to differentiate the actual schemas from the other data. In addition, I need to include the schema comments. So to summarize my particular need: I need to issue a select statement that returns "Schema Name" and "Comments" for the given database.
Cascade Data Solutions, Inc.
pgsql-novice by date
|Next:||From: Mladen Gogala||Date: 2010-08-10 20:16:36|
|Subject: Installation problem (RH5, x86-64, Postgresql 8.4.4)|
|Previous:||From: Bruce Momjian||Date: 2010-08-10 15:00:00|
|Subject: Re: How to remove quotes from COPY TO result?|