On Thu, Dec 4, 2008 at 1:27 PM, Pavel Stehule <[EMAIL PROTECTED]> 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'), '
2008/12/4 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>:
> to answer myself, and also make matter a bit more complicated.
> the table has like 20 columns, so - yes, I can probably name all of
> them one by one, but - is there any way to do it without need to name
> all of them ?
>
no,
regards
Pavel Ste
to answer myself, and also make matter a bit more complicated.
the table has like 20 columns, so - yes, I can probably name all of
them one by one, but - is there any way to do it without need to name
all of them ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
hey,
it looks , as if when I have two tables, say
create table foo(
a int,
b varchar,
c float
);
and :
create table bar(
b varchar,
a int,
c float
);
migration of data from one to the other using
insert into foo select * from bar; will fail.
How can I walk around that please ?
--
