pgsql dynamic insert query execution

Question

Facing issue while executing dynamic insert query in postgresql

query used in function.

EXECUTE 'INSERT INTO tblename_' ||  NEW.id|| ' VALUES ($1)' USING NEW.* ;

While executing the above line it throws this error

ERROR: query "SELECT NEW.*" returned 14 columns

lat long · Accepted Answer · 2017-12-21 07:33:33Z

1

I think You do not need the keyword "VALUES", as you are not specifying few selected columns. You can directly use it something like this

EXECUTE 'INSERT INTO tblename_' ||  NEW.id|| ' SELECT ($1).*'
USING NEW;

answered Dec 21, 2017 at 7:33

lat long

9306 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1