Re: Getting show results into a table

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>,"PostgreSQL General (pgsql-general(at)postgresql(dot)org)," <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting show results into a table
Date: 2012-11-28 18:53:58
Message-ID: 20121128185359.69330@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Little, Douglas wrote:

> 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);

insert into Config_history
 select name, setting, short_desc from pg_settings;

or maybe:

create table config_history as
 select name, setting, short_desc as description from pg_settings;

-Kevin

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2012-11-28 21:07:12 'alternatives'
Previous Message Little, Douglas 2012-11-28 18:38:36 Getting show results into a table