| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Douglas <douglas(dot)listas(at)brturbo(dot)com(dot)br> |
| Cc: | PostGreSQL - Ingles <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Get comment |
| Date: | 2004-12-11 01:55:30 |
| Message-ID: | 20041211015530.GA62445@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, Dec 10, 2004 at 08:16:06AM -0300, Douglas wrote:
> I have coments in some tables and columns, how to catch the coment on select ?
Adding a plus sign (+) to psql's \d commands usually shows comments
(\d+, \df+, etc.). If you want to select comments in your own
queries, you can find out how psql does it by running "psql -E" and
executing \d+. The -E option tells psql to display the queries it
executes for internal commands; from the output you can see how
psql gets the comments.
See also the "Functions and Operators" chapter of the documentation.
In 7.x see the "Miscellaneous Functions" section; in 8.0 see "System
Information Functions."
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2004-12-11 05:58:55 | Re: can't set sequence |
| Previous Message | Matthew Engelbert | 2004-12-11 00:57:02 | Re: Indexing Strategy |