Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I convert mdb file to PostgreSQL, the program keeps the double quote around the names of the database elements names.How can I remove the double quotes?

0
Posted

When I convert mdb file to PostgreSQL, the program keeps the double quote around the names of the database elements names.How can I remove the double quotes?

0

In PostgreSQL names (identifiers) are not case-sensitive (i.e. A=a) In order to keep upper case in your names our program convert the data with double quotes. To resolve the case “TableName” should be written as tablename. Please, use the option to “Use lowercase” at Customization step(Database Options). If you check this option all the names of the database elements will be converted in lower case. For example: TableName will be converted into tablename.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.