Skip to content

Instantly share code, notes, and snippets.

@svanellewee

svanellewee/rows_records.sql

Created February 24, 2017 11:09
Show Gist options
  • Save svanellewee/3f895e82dd000946d382bde190a1b11e to your computer and use it in GitHub Desktop.
Save svanellewee/3f895e82dd000946d382bde190a1b11e to your computer and use it in GitHub Desktop.
Download ZIP
PG SNIPPETS!
Raw
rows_records.sql
DO $$
declare
x node%rowtype;
begin
for x in SELECT * FROM node
loop
RAISE NOTICE 'hello ...% %', pg_typeof(x), x;
end loop;
end;
$$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment