How to SHOW custom variable classes?

Started by Simon Riggsalmost 20 years ago2 messagesgeneral
Jump to latest
#1Simon Riggs
simon@2ndQuadrant.com

How do you do
SHOW plperl.*
or whatever technique allows you to find out all custom parameters
defined for a particular class?

i.e. class.parameter

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Simon Riggs (#1)
Re: How to SHOW custom variable classes?

Simon Riggs <simon@2ndquadrant.com> writes:

How do you do
SHOW plperl.*
or whatever technique allows you to find out all custom parameters
defined for a particular class?

Maybe select from pg_settings where name like 'plperl.%'

regards, tom lane