On 2018-Dec-05, Togou, Hakim wrote:
> Hi David,
> I have already quoted the values, this is my query right now:
> 'INSERT INTO assetmanagement$asset("id","ticker","fullname")
> VALUES ('+'12345678910'+','+'test1'+','+'test2'+');
> It is an execute statement java action.
This is a completely different statement than you first showed --
completely different quoting in column names and values, etc. You need
to be very exact and strict about what you post, because one of those
quoting things is likely the cause of your problem. Don't try to
transcribe things manually ... you need to copy & paste instead.
You also need to show exactly what is the error message you're
obtaining. The server log might be useful too.
> I have tried everything to get the insert a record into an postgres db. This
> is my sql query:
> 'INSERT INTO public."assetmanagement$asset"(ticker, fullname)
> VALUES (test1,test2);'
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services