PGSQL dynamic table name

Powerful Penguin answered on October 29, 2021 Popularity 4/10 Helpfulness 1/10

answer PGSQL dynamic table name

Comment

EXECUTE format('SELECT count(*) FROM %I '
   'WHERE inserted_by = $1 AND inserted <= $2', tabname)
   INTO c
   USING checked_user, checked_date;

Popularity 4/10 Helpfulness 1/10 Language sql

Tags: dynamic sql

Link to this answer
Share Copy Link

Contributed on Oct 29 2021

Powerful Penguin

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.