CloudSQL Postgres ALTER USER name with "-"

Question

I am trying to grant a service account with - in postgres. Google Cloud service accounts are setup like user-action@project-environment.

so far I tried:

ALTER USER '[email protected]' WITH REPLICATION;
ALTER USER "[email protected]" WITH REPLICATION;
ALTER USER [email protected] WITH REPLICATION;

Not sure what the solution is.

1) What are the error messages you get? 2) Works here on community edition Postgres. 3) This is probably a question for Google support as Cloud SQL != Postgres community edition. — Adrian Klaver
– Adrian Klaver, Commented Mar 19 at 18:31
@LukaszSzozda Backticks are not allowed in PostgreSQL, it's not clear why you mentioned this. The double quotes " work fine in PostgreSQL: postgresql.org/docs/current/… — Frank Heikens
– Frank Heikens, Commented Mar 19 at 19:32
I tried the back-tick as well. that did not work. it is possible it is a GCP thing. I don't have regular postgresql setup. — Winston Kyu
– Winston Kyu, Commented Mar 19 at 21:39
Please explain the problem, like "CloudSQL Postgres ALTER USER name with "-" returns error xyz. — Bouke
– Bouke, Commented Mar 20 at 14:56

Jack Wotherspoon · Accepted Answer · 2025-03-19 22:11:18Z

1

For Cloud SQL Postgres IAM database authentication, IAM service account database users are created without the .gserviceaccount.com suffix.

You can find this mentioned here in the official docs:

For an IAM user, the username is the full email address of the user. For a service account, this is the service account's email without the .gserviceaccount.com domain suffix.

So in the case above you would use:

ALTER USER "[email protected]" WITH REPLICATION;

edited Mar 19 at 22:11

answered Mar 19 at 20:38

Jack Wotherspoon

2,0591 gold badge5 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Frank Heikens Mar 19 at 20:40

Are you sure the single quote ' is the right one? This won't work in PostgreSQL, you would need the double quote "

Winston Kyu Mar 19 at 21:38

I don't think that's the issue here. here is the error: Details: pq: syntax error at or near "'[email protected]'"

Jack Wotherspoon Mar 19 at 22:11

@FrankHeikens whoops thanks for catching that, I have updated my answer to use double quotes.

Jack Wotherspoon Mar 19 at 22:12

@WinstonKyu please try now with double quotes, i have updated the answer

Winston Kyu Mar 20 at 22:47

with the double quotes, it worked. thank you so much.

Collectives™ on Stack Overflow

CloudSQL Postgres ALTER USER name with "-"

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related