pgadmin-org / pgadmin-org/pgadmin4

Let pgAdmin be an option to open .sql files in Finder

Open
#10,345 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Feature
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

Describe the solution you'd like

Right-clicking a .sql file in macOS Finder presents an "Open With" option, as is standard for all files. However, pgAdmin is not presented as an option for opening the file. Moreover, clicking "Other ..." presents a list of apps, but pgAdmin is not selectable for assigning it to open .sql files.

Given that pgAdmin is one of my most-used .sql file editors, it would be helpful for it to be available as the default or as an option. I'm not sure if this can be set in the pgAdmin codebase or if macOS itself needs to be aware.

Finally, I don't know what the Windows corollary to this is as I don't have a Win machine handy.

Describe alternatives you've considered

Alternative is to do what I usually do, which is launch pgAdmin and then go find and open the .sql file.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by examining how the macOS application bundle and release packaging declare file-type associations, since no source file or test is identified in the issue. Determine whether pgAdmin can be registered for .sql files in Finder and whether Windows support is in scope. Done means the supported desktop package exposes pgAdmin as an option for opening .sql files.

Written by the indexing model from the issue text.

Assessment

Tech stack
macos, postgresql, python
Domain
databases, desktop
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.