On 2012-10-02, Chris McDonald wrote:
> Hi,
>
>
> If I had a single table targ to insert into I would do an
>
> INSERT INTO targ SELECT thiscol, thatcol, theothercol FROM FOO.
>
> The problem is that I have tables targ1, targ2, targn to insert things into
> and a nice stored procedure myproc whi
Thanks very much for that David - really appreciate your response - it works
like a dream
c
On Tuesday, 2 October 2012 19:42:59 UTC+1, Chris McDonald wrote:
> Hi,
>
>
>
>
>
> If I had a single table targ to insert into I would do an
>
>
>
> INSERT INTO targ SELECT thiscol, thatcol, th
> If I had a single table targ to insert into I would do an
>
> INSERT INTO targ SELECT thiscol, thatcol, theothercol FROM FOO.
>
> The problem is that I have tables targ1, targ2, targn to insert things
into and a
> nice stored procedure myproc which does the insertion into all 3 tables -
> pro
my apologies - forgot to say I am on postgresql 8.4.9 on Fedora Linux x86_64
c
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
