Re: syntax error with execute - Mailing list pgsql-general

From A B
Subject Re: syntax error with execute
Date
Msg-id dbbf25900806020048p4d650bfbned50c0f0409f066@mail.gmail.com
Whole thread Raw
In response to Re: syntax error with execute  ("Vyacheslav Kalinin" <vka@mgcp.com>)
List pgsql-general
> EXECUTE 'INSERT INTO '||tablename||' ('||fields||') VALUES
>  ('||vals||') RETURNING currval('''||seqname||''')' INTO newid
>
> Note where last quote goes.

That was exactly what I wanted to do!

SELECT 'Thank you' FROM heart;

pgsql-general by date:

Previous
From: "A B"
Date:
Subject: Re: Connection problem
Next
From: Hermann Muster
Date:
Subject: Accessing other databases with DBLink when leaving user/password empty