Thanks everybody. Always wondered where the command was sourcing the data. Thanks -----Original Message----- From: Guillaume Lelarge [mailto:guillaume@xxxxxxxxxxxx] Sent: Wednesday, November 28, 2012 3:24 PM To: Little, Douglas Cc: PostgreSQL General (pgsql-general@xxxxxxxxxxxxxx) Subject: Re: Getting show results into a table 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
