216 questions

223 answers

12 comments

334 users

Welcome to OSSbible, where you can ask Open Source Products questions and receive answers from members of the community. OSSbible has very active & vibrant community members whose knowledge is unparalleled.

Rename postgress database name scenarios.

+1 vote
asked Dec 1, 2015 in Linux by prithvi (2,660 points)

1 Answer

0 votes
As we used to go below command to rename database.

alter database mineworkers_testing3 rename to mineworkers_testing;

If database name is start with captal letter.We need to use double colon.

alter database "Mineworkers_testing3" rename to "Mineworkers_testing";
answered Dec 1, 2015 by rajashekar (1,610 points)

Related questions

...