Search Postgresql Archives

psql \df+ [pattern] with overloaded functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux