CODEWITHSUNDEEP
dbeaver
Eric Mamet
Eric Mamet

Reputation: 3671

does the file extension matter to DBeaver?

I have a SQL script file with the extension.pgsql

When I open it in DBeaver, it does not seem to recognise it as a SQL script and removes all options such as execute, etc...

If I change the extension from pgsql into sql, then everything is fine.

I do not have control over file extensions... Is there a way to instruct DBeaver to treat .pgsql as SQL files?

PS: I am using DBeaver 5.3.4 under windows

Upvotes: 2

Views: 1317

Answers (1)

Anepicpastry
Anepicpastry

Reputation: 542

Yes, the extension does matter and yes you can add file associations to treat .pgsql extensions as SQL files.

Go to File > Properties (Alt+Enter is default keybind). Then Click on Global Settings. Navigate to General > Editors > File Associations. Click Add and add .pgsql enter image description here

enter image description here

Then add an associated editor that is an sql editor. enter image description here

Upvotes: 4

Related Questions