: Re: [GENERAL] 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
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
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 ta
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 Chi
