Re: how to see column comments?
От | Christopher Sawtell |
---|---|
Тема | Re: how to see column comments? |
Дата | |
Msg-id | 01021616424300.11625@berty обсуждение исходный текст |
Ответ на | how to see column comments? ("Norman J. Clarke" <norman@combimatrix.com>) |
Список | pgsql-general |
You have to put the actual name (attribute) of the column, not "col1" On Fri, 16 Feb 2001 14:24, Norman J. Clarke wrote: > Hello, > > I have not been able to get psql to show column comments in version > 7.1beta4. Am I doing anything wrong, or is this a bug? A transcript of > my psql session is below. > > Norm > > ------------------------------------------------------------------ > > > norman=# create table test_table (col1 integer); > > CREATE > > norman=# comment on table test_table is 'this is a table comment'; > > COMMENT > > norman=# \dd test_table > > Object descriptions > Name | Object | Description > ------------+-------------+------------------------- > test_table | relation(r) | this is a table comment > (1 row) > > norman=# comment on column test_table.col1 is 'this is a column > comment'; > > COMMENT > > norman=# \dd test_table.col1 > > Object descriptions > Name | Object | Description > ------+--------+------------- > (0 rows) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--
В списке pgsql-general по дате отправления: