| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql feature request (\dd+) |
| Date: | 2010-05-15 01:43:13 |
| Message-ID: | 4BEDFC31.7080507@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 14/05/2010 11:35 PM, Richard Broersma wrote:
> It'd be nice if there was a \dd+ command to return all of the comments
> of dependent objects in addition to the specified object; i.e. all
> dependent objects related to a table for example.
What gets me with Pg's COMMENT ON is the way the comments have to be
separate from, and after, the objects they refer to. IMO it'd be
significantly preferable to have something like:
CREATE TABLE X (
somepk integer primary key,
cost numeric(10,2) COMMENT 'blah blah',
);
.. with a similar clause for CONSTRAINT.
Is there any particular objection to doing things this way? Or is it
just that nobody's been inclined to implement it (and fair enough, too) ?
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-05-15 02:15:36 | Re: psql feature request (\dd+) |
| Previous Message | Alvaro Herrera | 2010-05-15 01:15:34 | Re: hi, is it dangerous to only use tuple pointer through heap_getnext()? |