Re: Adding column comment to information_schema.columns

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Jochem van Dieten <jochemd(at)gmail(dot)com>
Cc: Hannu Krosing <hannu(at)tm(dot)ee>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding column comment to information_schema.columns
Date: 2004-07-03 11:07:59
Message-ID: 40E6938F.3000408@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-07-03 11:12:02 Re: working on support triggers on columns
Previous Message Simon Riggs 2004-07-03 10:15:17 Adding VERSION to startup log output