Обсуждение: how to see column comments?
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)
Try \d+ test_table.
Hope that helps,
Mike Mascari
mascarm@mascari.com
-----Original Message-----
From: Norman J. Clarke [SMTP:norman@combimatrix.com]
Sent: Thursday, February 15, 2001 8:24 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how to see column comments?
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)
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 <<--
Actually, I responded a bit too hastily. That looks like a bug in psql to
me. I see it in 7.0.3 as well. The query that psql is generating is
incorrect:
SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
FROM pg_class WHERE relname='table.column';
It should be querying pg_attribute.
It seems \d+ tablename is currently the only way to view column comments.
Hope that helps,
Mike Mascari
mascarm@mascari.com
-----Original Message-----
From: Norman J. Clarke [SMTP:norman@combimatrix.com]
Sent: Thursday, February 15, 2001 8:24 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how to see column comments?
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)
In psql, gethostbyname() is defined as taking a text parameter and return an
inet type value or reference.
However, if you do
psql=# select gethostbyname('www.postgres.org');
gethostbyname
---------------
<unprintable>
(1 row)
the inet address will be unprintable.
Has anyone got any idea?
Phillip Pan
-----------
<phillip@formstar.com> writes:
> In psql, gethostbyname() is defined as taking a text parameter and return an
> inet type value or reference.
Huh? There's no such function in the standard Postgres distribution.
regards, tom lane
phillip@formstar.com writes: > In psql, gethostbyname() is defined as taking a text parameter and return an > inet type value or reference. I don't see a function gethostbyname() in my copy. Where did you get it from and what is its source code? -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
> phillip@formstar.com writes: > > > In psql, gethostbyname() is defined as taking a text parameter and return an > > inet type value or reference. > > I don't see a function gethostbyname() in my copy. Where did you get it > from and what is its source code? Don't tell me it is one of those "grab from libc" tricks. CREATE FUNCTION getpid () returns int4 as '/lib/libc.so.6' LANGUAGE 'C'; SELECT getpid(); -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Fri, 16 Feb 2001, Tom Lane wrote: > <phillip@formstar.com> writes: > > In psql, gethostbyname() is defined as taking a text parameter and return an > > inet type value or reference. > > Huh? There's no such function in the standard Postgres distribution. If you do a '\df' at prompt, you will be able to see I am not lying. Phillip Pan -----------