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 40E6938F.3000408@familyhealth.com.au
Whole thread Raw
In response to Re: Adding column comment to information_schema.columns  (Jochem van Dieten <jochemd@gmail.com>)
List pgsql-hackers
> I didn't write that (or at least, I didn't mean to write that :-). The
> SQL standard tells that they will not use trailing underscores,
> therefore *my* conclusion is that it is future proof (from a standards
> perspective) if all PostgreSQL extensions use a trailing underscore.
> Which also gives an indication to the user that it is a PostgreSQL
> extension.

All you need to do is add an oid_ column then you can join the 
info_schema tables to the catalogs however you like.

Chris



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Adding VERSION to startup log output
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: working on support triggers on columns