Skip to main content

New answers tagged

0 votes

Using CURRENT_USER in Dynamic SQL Adds a Dot to the End of the Username

I believe your problem is not the exceeding period mark, but the format of the login used. The CREATE USER doc says: LOGIN login_name Specifies the login for which the database user is being created....
Ronaldo's user avatar
  • 5,079
0 votes

How to format an array of identifiers?

The function quote_literal seems to work. CREATE PROCEDURE make_mutable(IN t text, IN cs text[]) LANGUAGE plpgsql AS $$ BEGIN EXECUTE format( 'CREATE TRIGGER %I BEFORE UPDATE ON %I FOR EACH ...
ceving's user avatar
  • 317

Top 50 recent answers are included