216 questions

223 answers


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