From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: \df PATTERN, what pattern? |
Date: | 2003-07-24 23:17:56 |
Message-ID: | 20030724231756.GD13026@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 23, 2003 at 05:50:53PM +0900, Jean-Christian Imbeault wrote:
> The consoled help says that the useage for \df is \df [PATTERN]. What is
> the pattern matching on? How does one use the pattern?
>From the psql manual:
The various \d commands accept a pattern parameter to specify the
object name(s) to be displayed. * means "any sequence of characters"
and ? means "any single character". (This notation is comparable to
Unix shell file name patterns.) Advanced users can also use
regular-expression notations such as character classes, for example
[0-9] to match "any digit". To make any of these pattern-matching
characters be interpreted literally, surround it with double quotes.
A pattern that contains an (unquoted) dot is interpreted as a schema
name pattern followed by an object name pattern. For example, \dt
foo*.bar* displays all tables in schemas whose name starts with foo and
whose table name starts with bar. If no dot appears, then the pattern
matches only objects that are visible in the current schema search
path.
Whenever the pattern parameter is omitted completely, the \d commands
display all objects that are visible in the current schema search path.
To see all objects in the database, use the pattern *.*.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)
From | Date | Subject | |
---|---|---|---|
Next Message | elein | 2003-07-24 23:28:44 | Re: Fw: Is SQL silly as an RDBMS<->app interface? |
Previous Message | Dennis Gearon | 2003-07-24 21:43:02 | Re: SAP DB: The unsung Open Source DB |