Getting show results into a table - Mailing list pgsql-general

From Little, Douglas
Subject Getting show results into a table
Date
Msg-id 8585BA53443004458E0BAA6134C5A7FBB1D22289@EGEXCMB01.oww.root.lcl
Whole thread Raw
Responses Re: Getting show results into a table  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general

Is there a way in sql to get the results of the show all command into a table?

 

I’m expecting  something like

Insert into Config_history as select * from (show all);

 

 

 

Doug Little

 

Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Attachment

pgsql-general by date:

Previous
From: Wim Bertels
Date:
Subject: GRANT .. VIEW .. documentation
Next
From: "Kevin Grittner"
Date:
Subject: Re: Getting show results into a table