Thread: Fw: Running config vars
Hi all (I hope this is the correct list), Under Oracle there is v$parameter which list ALL config varables. Under psql there is the SHOW command, but this only lists 1 variable. I have written a shell script (attached) that shows ALL know variables. My questions is can this script get included under contrib directory and is there a way to make it into a view. I believe this kind of info will help in trouble shooting problems. thanks Jim
Attachment
I think the way to do this is for SHOW ALL to show all setttings. [ Charset ISO-8859-1 unsupported, converting... ] > > Hi all (I hope this is the correct list), > > Under Oracle there is v$parameter which list ALL config varables. Under > psql there is the SHOW command, but this only lists 1 variable. I have > written a shell script (attached) that shows ALL know variables. My > questions is can this script get included under contrib directory and is > there a way to make it into a view. I believe this kind of info will > help in trouble shooting problems. > > thanks > Jim > > > > > > [ application/octet-stream is not supported, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
I was looking for some way via standard SQL (I use perl DBI) to list these variables. I don't believe the SHOW command is available via DBI Jim > > I think the way to do this is for SHOW ALL to show all setttings. > > [ Charset ISO-8859-1 unsupported, converting... ] > > > > Hi all (I hope this is the correct list), > > > > Under Oracle there is v$parameter which list ALL config varables. Under > > psql there is the SHOW command, but this only lists 1 variable. I have > > written a shell script (attached) that shows ALL know variables. My > > questions is can this script get included under contrib directory and is > > there a way to make it into a view. I believe this kind of info will > > help in trouble shooting problems. > > > > thanks > > Jim > > > > > > > > > > > > > > [ application/octet-stream is not supported, skipping... ] > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > >