On Wed, 2012-11-28 at 12:38 -0600, Little, Douglas wrote: > Is there a way in sql to get the results of the show all command into a table? >
SELECT name, setting, short_desc FROM pg_settings > I'm expecting something like > Insert into Config_history as select * from (show all); > INSERT INTO config_history SELECT name, setting, short_desc FROM pg_settings; That should work. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
