Re: column name order matters in insert into foo from bar

On Thu, Dec 4, 2008 at 1:27 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

> p.s. you can try use stored procedure for generating these statements
yeah, I ended up generating it using:
 select  array_to_string(ARRAY(select column_name::text  FROM
information_schema.columns where table_name='foo'), ',');

This was one time thing anyway, so than simple copy and paste, etc ..

thanks folks.

--
GJ