kev
Reputation: 9715
How to rename an Amazon RDS hosted PostgreSQL database
I have restored a snapshot from an existing RDS PostgreSQL database. Now I want to rename that database but can't find how to do it anywhere in the AWS documentation.
Nor can I find how to use the master password (which I expect let's me do it).
Upvotes: 9
Views: 3334
Answers (1)
kev
Reputation: 9715
Logging in with postgres into template1 database and then ALTER DATABASE foo RENAME TO bar; worked
Upvotes: 5
Related Questions
- How can I change a PostgreSQL user password?
- How can I drop all the tables in a PostgreSQL database?
- How do I modify fields inside the new PostgreSQL JSON datatype?
- How to show tables in PostgreSQL?
- Import SQL dump into PostgreSQL database
- psql: FATAL: database "<user>" does not exist
- How to do an update + join in PostgreSQL?
- Insert, on duplicate update in PostgreSQL?
- How to exit from PostgreSQL command line utility: psql
- "use database_name" command in PostgreSQL