On Wed, Mar 26, 2008 at 01:14:07PM +0100, josep porres wrote:
> I've tried:
>
> EXECUTE 'INSERT INTO F2_TEMPFAC SELECT * FROM row_tempf';
I think that:
INSERT INTO f2_tempfac
SELECT (row_tempf).*;
should do what you want. Unless you're doing something very fancy you
don't want the execute either. You can just put normal SQL statements
in the code and they'll get run as normal, expanding variables when
needed.
Sam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
