On Fri, Aug 14, 2015 at 9:17 PM, Ken Tanzer <[email protected]> wrote:
> On Fri, Aug 14, 2015 at 6:35 PM, David Nelson <[email protected]> > wrote: > >> On Fri, Aug 14, 2015 at 10:00 AM, Tom Lane <[email protected]> wrote: >> > >> > David Rowley <[email protected]> writes: >> > > >> Tthat is the way I would do it for a table with a small number of >> columns, but these have several dozen so this would get tedious. Although I >> just realized I could output the list of column names from the pg_stat view >> to a file and whip up some vi find and replace to create the entire >> statement pretty quickly. I was just wondering if that was the only way or >> not. >> > > You could use this to generate the SQL: > > \set my_table my_real_table_name > > SELECT 'SELECT COUNT(*) AS total_rows, '||array_to_string(array(SELECT > 'COUNT('||column_name::text ||') AS ' || column_name::text FROM > information_schema.columns WHERE table_name=:'my_table'),E',\n') || ' FROM > ' || :'my_table' || ';'; > Oh yeah, SQL to generate SQL. Done it many times to create ETL scripts. Don't know why I didn't think of that here. Definitely a viable option. Thanks Ken. > > Cheers, > Ken > -- > AGENCY Software > A Free Software data system > By and for non-profits > *http://agency-software.org/ <http://agency-software.org/>* > *https://agency-software.org/demo/client > <https://agency-software.org/demo/client>* > [email protected] > (253) 245-3801 > > Subscribe to the mailing list > <[email protected]?body=subscribe> to > learn more about AGENCY or > follow the discussion. >
