Prepared SQL statements

Tags: postgres, sql

aka Parameterized Query

1: PREPARE foo(int) AS
2:   SELECT * FROM users where id = $1;
3: EXECUTE foo(1);
4: DEALLOCATE foo;

• Prepared statements only last for the duration of the current database session, but can be cleaned up manually with DEALLOCATE
• See Postgres PREPARE