SRP
0
I use the tool "dbeaver" to request on a Redshift server. I don't understand what language i have to use.
Some functions like "LAST_DAY" doesn't exist so i thought i have to use PostgreSQL, who doesn't work either.
Can Dbeaver give me the correct information ?
Thanks for your help
It is best to choose the Driver that matches the database so that they can properly communicate. Sometimes, an alternate driver is acceptable because Amazon Redshift was originally based on PostgreSQL.
The driver is merely the means of communication with the database. It does not impact which commands can be used. All commands are sent to, and executed on, the database server.
The LAST_DAY function is available in Amazon Redshift. See: LAST_DAY function - Amazon Redshift