Skip to content

Instantly share code, notes, and snippets.

@junosuarez

junosuarez/gist:ee9039874512fd34ea20

Created March 19, 2015 18:01
Show Gist options
  • Save junosuarez/ee9039874512fd34ea20 to your computer and use it in GitHub Desktop.
Save junosuarez/ee9039874512fd34ea20 to your computer and use it in GitHub Desktop.
Download ZIP
log select query in transaction (postgres 9+)
Raw
gistfile1.sql
DO language plpgsql $$ DECLARE result RECORD; BEGIN
select * into result from table limit 1;
RAISE NOTICE '%', result; END$$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment