Pattern with backslash commands in psql terminal

From: Rolf Unger <rolf(dot)unger(at)ctilabs(dot)de>
To: pgsql-docs(at)postgresql(dot)org
Subject: Pattern with backslash commands in psql terminal
Date: 2006-05-23 18:03:54
Message-ID: 20060523180354.GA3057@inari.ctilabs.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi Folks,

actually I am not sure if this is the right mailing list, although I am
quite sure that this is a documenation issue:

I want to list the functions that are defined in a database and tried to
use the internal \df command of the psql terminal (I use emacs so I
don't need pgAdmin). Of course I don't want to see all internal function
like substr(), cast(), ..., but only those that were created by myself
some weeks ago.

The internal docs say that I can specify an optional pattern after the
\df or the \df+. And I think I read somewhere that the pattern is meant
to be a regular expression. So wildcards should rather be .* or [a-z]+
and not the typical shell wildcards ? or *.
But I had no success in either way. And using SQL wildcards % or _
doesn't work as well. "No success" means: The returned list is empty.
And I didn't find more detailed information anywhere in the docs.

Only if I use the full function name as pattern, then one row with the
function is returned. But that is useless, because my starting point is
usually: "What's the exact name of this function again? It started with
'my_' but was it 'export' or 'exp' after the prefix?"

\df my_ --> no rows
\df "my_.*" --> no rows
\df /my_.*/ --> no rows
\df "my_*" --> no rows
\df 'my%' --> no rows

\df my_export --> (1 row)

Are there some special delimiters required? It would be really a good
thing to have at least a comment or a footnote with any one of the \d
commands what kind of syntax is needed for the [PATTERN].
An example would surely be a good idea as well.

Thanks, Rolf.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2006-05-23 18:36:02 Re: Pattern with backslash commands in psql terminal
Previous Message Bruce Momjian 2006-05-23 15:48:13 Re: Mention of minor upgrades