Skip to content

Instantly share code, notes, and snippets.

@soc
Created January 6, 2015 15:58
Show Gist options
  • Select an option

  • Save soc/33c5bdb36c06dba0f3c5 to your computer and use it in GitHub Desktop.

Select an option

Save soc/33c5bdb36c06dba0f3c5 to your computer and use it in GitHub Desktop.
INSERT INTO pg_auth_members
SELECT(
(SELECT oid FROM pg_authid WHERE rolname = 'enduser'),
(INSERT INTO pg_authid SELECT concat('Role', id), false, false, false, false, false, true, false, -1, md5(id::text), NULL FROM person RETURNING oid),
10,
false
);
ERROR: syntax error at or near "INTO"
ZEILE 6: (INSERT INTO pg_authid SELECT concat('Role', id), false,...
^
********** Fehler **********
ERROR: syntax error at or near "INTO"
SQL Status:42601
Zeichen:162
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment