Connection problems with databases with spaces in the name. [FireDAC][Phys][PG][libpq] database does not exist

Emmanuel Millan

19 hours ago

Hi Support Team / FlySpeed Community,

I am facing connection problems with PostgreSQL databases with spaces in the name. The error we get is the following:
[FireDAC][Phys][PG][libpq] database "database name" does not exist.

I can connect without problems to databases on the same server if they do not have spaces in the name. I tested the connection using pgAdmin, and everything works fine.

I am using FlySpeed SQL Query Version: 4.10.2.0 on a Windows 11 PC, the PostgreSQL version is 16.4 running as a localhost server.

Regards