How should a hyphenated PostgreSQL database name be quoted?

Jun13 Oct

I want to give a database a new name containing a hyphen (-).

ALTER DATABASE primarydb
RENAME TO primarydb-secondary;

But psql reports this error:

ERROR:  syntax error at or near "-"

Which escape sequence handles the "-" character, or how should I accomplish this?

Note: I also tried '-' without any success.

Thank you.

The conversation continues 3

Follow the reasoning

Agnes13 Oct Permalink
Putting it inside double quotes should work. However, every reference to that database will need to keep using the quoted identifier.
```
ALTER DATABASE primarydb
RENAME TO "primarydb-secondary";
```
tally61 day ago Permalink
psql -d -c "CREATE EXTENSION IF NOT EXISTS "'"uuid-ossp"'";"
mulchpile14 hours ago Permalink
Combine single and double quoting in this way:
```
psql --command='create database "store-db-with-hyphens"'
```