Re: Adding column comment to information_schema.columns - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Adding column comment to information_schema.columns
Date
Msg-id 40E8DB58.8010807@familyhealth.com.au
Whole thread Raw
In response to Re: Adding column comment to information_schema.columns  (Justin Clift <jc@telstra.net>)
List pgsql-hackers
> One other benefit of having more stuff in information_schema.* is that 
> the stuff there is "easier" to look at and figure out what it is.  With 
> the view definitions that are provided to things like psql and pgAdmin 
> when people look at an information_schema view, it provides them a way 
> of figuring out where in the internal tables stuff is if they want to 
> look for it.  i.e. they can find a column in 
> information_schema.constraint_column_usage and go "gee where is that in 
> the real PostgreSQL tables"?  Then look at the code that generates it 
> and so on.

OK, so make a pg_columns system view.

Chris



pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: Adding column comment to information_schema.columns
Next
From: Tom Lane
Date:
Subject: Re: Adding column comment to information_schema.columns