Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


database name to start with number

on 11/30/14, 2:41 AM 890 views

I have to create db name starting with number; when I start duplicate an existing db and give number then it shows invalid name.  Is there any kind of restriction setup for Postgres; how can I override/change that restriction?



| 5 3 6
Jakarta, Indonesia
On 11/30/14, 11:01 PM

In PostgreSQL, if you use number in front or capital letter anywhere in the object name, you need to surround the name with double quote: "70_this_is_my_database"

Hi John, I tried both double & single quotes but OpenERP is saying "Invalid database name".

Amit Sharma, AMITS
on 12/1/14, 1:57 AM

Are you trying to duplicate from the Manage Database? Sorry I did not catch that earlier, but from that menu you can only use names that starts not with numbers and does not contain capital letters. You can later rename it using PostgreSQL's tools.

on 12/1/14, 2:25 AM

I had tried by creating new as well as duplicating. Both times I was getting error of invalid database name. I will try by replacing it directly in PostgreSQL.

Amit Sharma, AMITS
on 12/1/14, 2:37 AM

Yes for both creating and duplicating database from Manage Database you need to specify name that does not start with number and does not contain capital letters.

on 12/1/14, 2:50 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 11/30/14, 2:41 AM
Seen: 890 times
Last updated: 3/16/15, 8:10 AM