Re: How can I select a comment on a column in a query?
От | George Weaver |
---|---|
Тема | Re: How can I select a comment on a column in a query? |
Дата | |
Msg-id | 006301c3dea2$bf157ab0$6400a8c0@Dell4500 обсуждение исходный текст |
Ответ на | How can I select a comment on a column in a query? (A u r k a <aurka@centrum.cz>) |
Ответы |
Re: How can I select a comment on a column in a query?
|
Список | pgsql-novice |
Hi Roman, Comments are stored in the system catalog table pg_description. To select a column comment ("description" in pg_description) you need the specify the objoid for the table ("relfilenode" from pg_class for the table in question) and the column number ("objsubid"). test=# select description from pg_description where objoid = 306461 and objsubid = 0; description ----------------------------------- Weight Units~Unit~unitdescription (1 row) HTH, George ----- Original Message ----- From: "A u r k a" <aurka@centrum.cz> To: <pgsql-novice@postgresql.org> Sent: Thursday, January 15, 2004 9:04 AM Subject: [NOVICE] How can I select a comment on a column in a query? > Hello, > > I have been going through the manuals for couple of hours looking for a > way to select a comment on a column in a query. Can it be done (and used > with php)? > > Thanks for any advice > > Roman Dergam > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-novice по дате отправления: