Обсуждение: Re: [HACKERS] Re: ORACLE COMMENT statement

Поиск
Список
Период
Сортировка

Re: [HACKERS] Re: ORACLE COMMENT statement

От
Mike Mascari
Дата:
--- Peter Eisentraut <peter_e@gmx.net> wrote:
> Anyway, the \dd command was kind of odd in that it
> only displayed comments
> but not what the comments went with.
> 
> The way I currently have implemented the comments is
> like this:
> (Ignoring the actual output format, which is
> currently under _heavy_
> development.)
> 
> peter@localhost:5432 play=> \d foobar
> Table "foobar"
>  
> Attribute |     Type     |   Info
> ----------+--------------+---------
> a         | numeric(9,2) | not null
> b         | varchar(5)   |
> c         | char(10)     |
> d         | char(1)      |
> 
> peter@localhost:5432 play=> \set description ""
> peter@localhost:5432 play=> \d foobar
> Table "foobar"
>  
> Attribute |     Type     |   Info   | Description
> ----------+--------------+----------+------------
> a         | numeric(9,2) | not null |
> b         | varchar(5)   |          |
> c         | char(10)     |          |
> d         | char(1)      |          |
> 
> peter@localhost:5432 play=> \l
> List of databases
>  
> Database  |  Owner   | Encoding |             
> Description
>
----------+----------+----------+---------------------------------------
> play      | postgres |        0 |
> pwdb      | peter    |        0 |
> template1 | postgres |        0 |
> twig      | httpd    |        0 | This is for that
> Twig mailer under PHP
>  
> (4 rows)
> 
> peter@localhost:5432 play=> \unset description
> peter@localhost:5432 play=> \l
> List of databases
>  
> Database  |  Owner   | Encoding
> ----------+----------+---------
> play      | postgres |        0
> pwdb      | peter    |        0
> template1 | postgres |        0
> twig      | httpd    |        0
>  
> (4 rows)
> 
> peter@localhost:5432 play=> \dd
> Object descriptions
> 
>        Name        |   What   | Description
>
-------------------+----------+------------------------------------------
> !                  | operator | fraction
> !!                 | operator | fraction
> !!=                | operator | not in
> !~                 | operator | does not match
> regex., case-sensitive
> !~*                | operator | does not match
> regex., case-insensitive
> !~~                | operator | does not match LIKE
> expression
> #                  | operator | intersection point
> --<snip>--
> varcharne          | function | not equal
> varcharoctetlen    | function | octet length
> version            | function | PostgreSQL version
> string
> width              | function | box width
> xid                | type     | transaction id
> xideq              | function | equal
> |                  | operator | start of interval
> |/                 | operator | square root
> ||                 | operator | concatenate
> ||/                | operator | cube root
> ~                  | operator | contains
> ~                  | operator | matches regex.,
> case-sensitive
> ~                  | operator | path contains point?
> ~                  | operator | polygon contains
> point?
> ~*                 | operator | matches regex.,
> case-insensitive
> ~=                 | operator | same as
> ~~                 | operator | matches LIKE
> expression
>  
> (973 rows)
> 
> peter@localhost:5432 play=> \dd version
> Object descriptions
>  
>  Name   |   What   |        Description
> --------+----------+--------------------------
> version | function | PostgreSQL version string
>  
> (1 row)
> 
> 
> Now if we just put a description on every
> pre-installed entity (in
> particular system tables), this is almost like a
> built-in quick reference!
> 
> The \dd doesn't do rules yet, I think. But I'll put
> that in soon.
> 
> So do you see that as a feasible solution?
> 
>     -Peter

I can't speak for others, but I sure like it.

Mike Mascari
(mascarim@yahoo.com)


=====

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com


Re: [HACKERS] Re: ORACLE COMMENT statement

От
Bruce Momjian
Дата:
Wow, that is nice.



> --- Peter Eisentraut <peter_e@gmx.net> wrote:
> > Anyway, the \dd command was kind of odd in that it
> > only displayed comments
> > but not what the comments went with.
> > 
> > The way I currently have implemented the comments is
> > like this:
> > (Ignoring the actual output format, which is
> > currently under _heavy_
> > development.)
> > 
> > peter@localhost:5432 play=> \d foobar
> > Table "foobar"
> >  
> > Attribute |     Type     |   Info
> > ----------+--------------+---------
> > a         | numeric(9,2) | not null
> > b         | varchar(5)   |
> > c         | char(10)     |
> > d         | char(1)      |
> > 
> > peter@localhost:5432 play=> \set description ""
> > peter@localhost:5432 play=> \d foobar
> > Table "foobar"
> >  
> > Attribute |     Type     |   Info   | Description
> > ----------+--------------+----------+------------
> > a         | numeric(9,2) | not null |
> > b         | varchar(5)   |          |
> > c         | char(10)     |          |
> > d         | char(1)      |          |
> > 
> > peter@localhost:5432 play=> \l
> > List of databases
> >  
> > Database  |  Owner   | Encoding |             
> > Description
> >
> ----------+----------+----------+---------------------------------------
> > play      | postgres |        0 |
> > pwdb      | peter    |        0 |
> > template1 | postgres |        0 |
> > twig      | httpd    |        0 | This is for that
> > Twig mailer under PHP
> >  
> > (4 rows)
> > 
> > peter@localhost:5432 play=> \unset description
> > peter@localhost:5432 play=> \l
> > List of databases
> >  
> > Database  |  Owner   | Encoding
> > ----------+----------+---------
> > play      | postgres |        0
> > pwdb      | peter    |        0
> > template1 | postgres |        0
> > twig      | httpd    |        0
> >  
> > (4 rows)
> > 
> > peter@localhost:5432 play=> \dd
> > Object descriptions
> > 
> >        Name        |   What   | Description
> >
> -------------------+----------+------------------------------------------
> > !                  | operator | fraction
> > !!                 | operator | fraction
> > !!=                | operator | not in
> > !~                 | operator | does not match
> > regex., case-sensitive
> > !~*                | operator | does not match
> > regex., case-insensitive
> > !~~                | operator | does not match LIKE
> > expression
> > #                  | operator | intersection point
> > --<snip>--
> > varcharne          | function | not equal
> > varcharoctetlen    | function | octet length
> > version            | function | PostgreSQL version
> > string
> > width              | function | box width
> > xid                | type     | transaction id
> > xideq              | function | equal
> > |                  | operator | start of interval
> > |/                 | operator | square root
> > ||                 | operator | concatenate
> > ||/                | operator | cube root
> > ~                  | operator | contains
> > ~                  | operator | matches regex.,
> > case-sensitive
> > ~                  | operator | path contains point?
> > ~                  | operator | polygon contains
> > point?
> > ~*                 | operator | matches regex.,
> > case-insensitive
> > ~=                 | operator | same as
> > ~~                 | operator | matches LIKE
> > expression
> >  
> > (973 rows)
> > 
> > peter@localhost:5432 play=> \dd version
> > Object descriptions
> >  
> >  Name   |   What   |        Description
> > --------+----------+--------------------------
> > version | function | PostgreSQL version string
> >  
> > (1 row)
> > 
> > 
> > Now if we just put a description on every
> > pre-installed entity (in
> > particular system tables), this is almost like a
> > built-in quick reference!
> > 
> > The \dd doesn't do rules yet, I think. But I'll put
> > that in soon.
> > 
> > So do you see that as a feasible solution?
> > 
> >     -Peter
> 
> I can't speak for others, but I sure like it.
> 
> Mike Mascari
> (mascarim@yahoo.com)
> 
> 
> =====
> 
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
> 
> ************
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026