EXECUTE IMMEDIATE

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1

Historical version. PostgreSQL 10 has reached end of support. 2022-11-10. See the current manual.

EXECUTE IMMEDIATE
Prev	Up	35.14. Embedded SQL Commands	Home	Next

EXECUTE IMMEDIATE — dynamically prepare and execute a statement

Synopsis

EXECUTE IMMEDIATE string

EXECUTE IMMEDIATE immediately prepares and executes a dynamically specified SQL statement, without retrieving result rows.

string: A literal C string or a host variable containing the SQL statement to be executed.

Here is an example that executes an INSERT statement using EXECUTE IMMEDIATE and a host variable named command:

sprintf(command, "INSERT INTO test (name, amount, letter) VALUES ('db: ''r1''', 1, 'f')");
EXEC SQL EXECUTE IMMEDIATE :command;

EXECUTE IMMEDIATE is specified in the SQL standard.

Prev	Up	Next
DISCONNECT	Home	GET DESCRIPTOR

Read the upstream documentation. For corrections, first check the current manual.