Thread: Table & Column descriptions
I am able to add table and column descriptions, and I am also able to retrieve the table description. The problem isthat I can not find a way to retrieve the description comments on table columns???? Any assistance would be greatly appreciated. Dale.
\d+ <tablename> should show you the table schema with comments. If you're looking for the actual data, it's in pg_description. The objoid field matches the oid field in pg_attribute (which is the "fields" table for pgsql). On 30 Nov 2000, at 11:17, Dale Anderson wrote: > I am able to add table and column descriptions, and I am also able > to retrieve the table description. The problem is that I can not > find a way to retrieve the description comments on table > columns???? Any assistance would be greatly appreciated. > > Dale. > -- Joel Burton, Director of Information Systems -*- jburton@scw.org Support Center of Washington (www.scw.org)
That is exactly what I was looking for. Thanks a lot. Dale. >>> "Joel Burton" <jburton@scw.org> 11/30/00 01:29PM >>> \d+ <tablename> should show you the table schema with comments. If you're looking for the actual data, it's in pg_description. The objoid field matches the oid field in pg_attribute (which is the "fields" table for pgsql). On 30 Nov 2000, at 11:17, Dale Anderson wrote: > I am able to add table and column descriptions, and I am also able > to retrieve the table description. The problem is that I can not > find a way to retrieve the description comments on table > columns???? Any assistance would be greatly appreciated. > > Dale. > -- Joel Burton, Director of Information Systems -*- jburton@scw.org Support Center of Washington (www.scw.org)