Browse the Postgres database

feature
#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