psql \df+ [pattern] with overloaded functions

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

Responses

Browse pgsql-general by date

  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?