psql \df+ [pattern] with overloaded functions - Mailing list pgsql-general

From Richard Broersma
Subject psql \df+ [pattern] with overloaded functions
Date
Msg-id 396486430808210918j31e092fyecf228a588acf7cb@mail.gmail.com
Whole thread Raw
Responses Re: psql \df+ [pattern] with overloaded functions  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Using psql, how can I use specify a pattern for \df+ to only show a
single overloaded function.  The following is a list of my overloaded
functions, and following this is an example what what happens when I
try to limit the list by including the function signature.

instrumentation=> \df update_history*
                                            List of functions
 Schema  |      Name      | Result data type |
Argument data types
---------+----------------+------------------+------------------------------------------------------------
 history | update_history | void             | new dev.analyzers, old
dev.analyzers
 history | update_history | void             | new dev.controlvalves,
old dev.controlvalves
 history | update_history | void             | new dev.dcsgraphics,
old dev.dcsgraphics
 history | update_history | void             | new dev.devicetypes,
old dev.devicetypes
 history | update_history | void             | new dev.hardsignals,
old dev.hardsignals
 history | update_history | void             | new
dev.instrumentassemblies, old dev.instrumentassemblies
 history | update_history | void             | new
dev.instrumenttypes, old dev.instrumenttypes
 history | update_history | void             | new
dev.loopcontainment, old dev.loopcontainment
 history | update_history | void             | new dev.looptimelines,
old dev.looptimelines
 history | update_history | void             | new dev.managers, old
dev.managers
 history | update_history | void             | new dev.manufactures,
old dev.manufactures
 history | update_history | void             | new dev.miscinstrument,
old dev.miscinstrument
 history | update_history | void             | new dev.nontagdevices,
old dev.nontagdevices
 history | update_history | void             | new dev.orificeplates,
old dev.orificeplates
 history | update_history | void             | new dev.partsupplies,
old dev.partsupplies
 history | update_history | void             | new dev.plcpoints, old
dev.plcpoints
 history | update_history | void             | new dev.pressuregauges,
old dev.pressuregauges
 history | update_history | void             | new dev.proctypes, old
dev.proctypes
 history | update_history | void             | new dev.projects, old
dev.projects
 history | update_history | void             | new
dev.signalingdevices, old dev.signalingdevices
 history | update_history | void             | new dev.signals, old dev.signals
 history | update_history | void             | new dev.switches, old
dev.switches
 history | update_history | void             | new dev.systems, old dev.systems
 history | update_history | void             | new dev.tagables, old
dev.tagables
 history | update_history | void             | new dev.tags, old dev.tags
 history | update_history | void             | new dev.vendors, old dev.vendors
 history | update_history | void             | new dev.vendorsupplies,
old dev.vendorsupplies
 history | update_history | void             | new dev.xmtrctrlind,
old dev.xmtrctrlind
 history | update_history | void             | new docs."p&ids", old
docs."p&ids"
 history | update_history | void             | new docs.dcsdocs, old
docs.dcsdocs
 history | update_history | void             | new docs.documentedin,
old docs.documentedin
 history | update_history | void             | new docs.documents, old
docs.documents
 history | update_history | void             | new
docs.projectdcschanges, old docs.projectdcschanges
 history | update_history | void             | new equ.equipment, old
equ.equipment
 history | update_history | void             | new equ.panels, old equ.panels
 history | update_history | void             | new equ.processunits,
old equ.processunits
(36 rows)

instrumentation=> \df+ update_history( dev.analyzers, dev.analyzers )*
ERROR:  invalid regular expression: parentheses () not balanced
instrumentation=>

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: "Amber"
Date:
Subject: Re: What's size of your PostgreSQL Database?
Next
From: Robert Gobeille
Date:
Subject: Re: plpgsql - sorting result set