print(is_select_query("SELECT * FROM users")) # True
print(is_select_query("WITH x AS (SELECT 1) SELECT * FROM x")) # True
print(is_select_query("INSERT INTO users(name) VALUES ('Alice')")) # False
print(is_select_query("SELECT 1; DELETE FROM users")) # False
Bertrand
Le 31 août 2026 à 18:06, Ron Johnson <ronljohnsonjr@gmail.com> a écrit :
Sometimes, the developers add comments to the top of statements, and so we see that in pg_stat_activity.query as seen in this example:
select query from pg_stat_activity where pid = 1054079; query ----------------------------------------
-- Some comment written by the developer SELECT blah blah FROM .blah
I could case-insensitively search pg_stat_activity.query for "SELECT " but that will fail if there is a SELECT in the CTE or subquery of a DELETE or UPDATE statement, and writing a parser to strip out all comments is a bit too much effort for a simple query.
