From: | "Gene Selkov, Jr(dot)" <selkovjr(at)mcs(dot)anl(dot)gov> |
---|---|
To: | "J(dot) Roeleveld" <j(dot)roeleveld(at)softhome(dot)net> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] item descriptions in psql |
Date: | 1999-12-22 09:00:38 |
Message-ID: | 199912220757.BAA26921@mail.xnet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Hi,
>
> I just found a reference to descriptions to functions/tables/...etc.
> and am now wondering how to add them myself?
>
> Joost Roeleveld
not sure if there is a shortcut to this (it's short enough already):
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your description' FROM pg_class WHERE relname = 'your_table_name';
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your description' FROM pg_proc WHERE proname = 'your_procedure_name';
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your description' FROM pg_type WHERE typname = 'your_type_name';
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your description' FROM pg_operator WHERE oprname = 'your_operator_name';
(in case of operators, oprname is '=', '<=', '>>~', etc.)
in older versions (pre-6.3), one had to typecast the names and descriptions:
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your description'::text FROM pg_type WHERE typname = 'your_type_name'::name;
--Gene
From | Date | Subject | |
---|---|---|---|
Next Message | J. Roeleveld | 1999-12-22 10:04:56 | getting user-list |
Previous Message | Mike Mascari | 1999-12-22 08:29:59 | Re: [GENERAL] item descriptions in psql |