Postgres Pro
Downloads
Home   >   mailing lists

\df PATTERN, what pattern? - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject \df PATTERN, what pattern?
Date
Msg-id 3F1E4C6D.8090509@mega-bucks.co.jp
Whole thread Raw
Responses Re: \df PATTERN, what pattern?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Tree view 
The consoled help says that the useage for \df is \df [PATTERN]. What is
the pattern matching on? How does one use the pattern?

I have tried "patterns" (function name, data type, schema name) but none
matched anything ...

Also how does one get a listing of all functions? A \df gives me:

"trigger"                   | public     | pot_documents_duplicate_check
         |
"trigger"                   | public     | pot_hostnames_duplicate_check
         |
"trigger"                   | public     |
pot_operating_systems_duplicate_check |
"trigger"                   | public     | pot_referers_duplicate_check
          |
"trigger"                   | public     |
pot_user_agents_duplicate_check       |


I see all the triggers I have defined but not the functions that those
triggers use or any other functions I have created ...

Thanks,

Jean-Christian Imbeault

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: birthday calculation
Next
From: Paul Thomas
Date:
Subject: Re: pg_dump problem