local/postgresql-user-create

   1 #!/bin/sh -eux
   2 user="$1"
   3 db="${2-}"
   4 sudo -u postgres psql "${db-}" -a -f - --set ON_ERROR_STOP=1 <<-EOF
   5         DO LANGUAGE plpgsql \$\$
   6         BEGIN
   7                 IF NOT EXISTS (
   8                  SELECT *
   9                  FROM pg_catalog.pg_user
  10                  WHERE usename = '$user'
  11                  LIMIT 1
  12                 ) THEN
  13                         CREATE ROLE $user
  14                          LOGIN
  15                          NOCREATEDB
  16                          NOCREATEROLE
  17                          NOINHERIT
  18                          NOSUPERUSER;
  19                 END IF;
  20         END;
  21         \$\$;
  22         GRANT USAGE ON SCHEMA public TO $user;
  23         ${db:+GRANT CONNECT,TEMPORARY ON DATABASE $db TO $user;}
  24         EOF