Browse the Postgres database

Contribute Feature

AI-generated summary

Users are discussing ways to browse the Postgres database. cokestroke initially sought a PHPMyAdmin-like solution, but merefield suggested using pgAdmin or the Data Explorer Plugin. After trying the plugin, cokestroke found it less intuitive due to requiring SQL knowledge and sought a more visual approach with pgAdmin. merefield uses pgAdmin locally with an ssh tunnel for remote instances, but notes potential additional setup for prod instances in docker containers. pfaffman suggests that writing SQL for the report might be easier than setting up pgAdmin, and that even with pgAdmin, the desired report might require exporting data to Excel.

1

Hi everyone,
Is there a way to browse the database with something like PHPMyAdmin?
I can download backups but my MySQL Workbench crashes every time I try to run the script to restore the database.
-Clement

2

I’ve used pgAdmin for this purpose.

But first consider the Data Explorer Plugin.

3 Likes
3

Thanks @merefield will take a look.

2 Likes
5

The Data Explorer plugin is fine but I’m more of a visual person and it would take me a while to figure out what SQL to write. Can PGAdmin connect to the database the same way as Data Explorer or will I need to set up a local copy on my machine to query things?

What I’m trying to do is generate a report or report of users along with the custom user fields I added.

6

I use pgAdmin client locally to browse a remote non-docker dev instance via an ssh tunnel.

There might be some additional hoops if you want to connect to a prod instance inside the docker container.

2 Likes
7

That makes sense.

I think it’ll be easier to write or get help with the SQL than it will be to get pgadmin set up, and I think that even if you do get pgadmin set up, you still won’t have an easy way to get the report you want (unless you’re going to pull a couple tables into excel or something?)

2 Likes