Re: Re: BETWEEN clause

From: Joel Burton <jburton(at)scw(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: will trillich <will(at)serensoft(dot)com>, pgsql-general(at)postgresql(dot)org, Paul Tomblin <ptomblin(at)xcski(dot)com>
Subject: Re: Re: BETWEEN clause
Date: 2001-04-24 20:11:22
Message-ID: Pine.LNX.4.21.0104241609270.19243-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Tue, 24 Apr 2001, Bruce Momjian wrote:

> > see "\h comment" for more on comments/descriptions.
> > (anybody using those for anything, by the way?)

I often link PG dbs to Access front ends, and have a VBA script that digs
the descriptions out of the pg_desc table to use as the Access description
(which the Access GUI automatically shows as help, etc.)

So, yes, I find them useful.

One small point I learned recently: you can used regular expressions with
the \d* commands. So, to find all functions that start with 'web_':

\df web_

to find all that *contain* web:

\df .*web_.*

Nifty!

--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Mahoney 2001-04-24 20:12:22 Re: IBM to buy Informix
Previous Message will trillich 2001-04-24 19:59:38 Re: Insert data into multiple tables

Browse pgsql-novice by date

  From Date Subject
Next Message esavas 2001-04-24 20:15:43 DROP COLUMN ?
Previous Message Bruce Momjian 2001-04-24 19:27:16 Re: Re: BETWEEN clause