From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | psql \df+ [pattern] with overloaded functions |
Date: | 2008-08-21 16:18:42 |
Message-ID: | 396486430808210918j31e092fyecf228a588acf7cb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Gobeille | 2008-08-21 16:35:25 | Re: plpgsql - sorting result set |
Previous Message | Amber | 2008-08-21 14:17:06 | Re: What's size of your PostgreSQL Database? |