Postgres ships with a powerful binary client,
psql. If you're not a command line person, it can take a little getting used to. It's worth the investment, however, because the speed and scriptability of
psql is extremely powerful.
You can login to your database with a simple command:
Once you're in, you can have a look around and see what's there:
\d \d csvs.*
If you run a query on our
master_plan table, you'll quickly find the results unreadable, which means we should use expanded display using
\x - and sometimes that doesn't even help!
The easiest thing to do is to specify what you want to see, and to be sure you limit the results. This is our first
select start_time_utc, duration, date from csvs.master_plan limit 5;
If you want to use a web-based GUI, you can run PG Web using Docker:
pgweb: container_name: pgweb restart: always image: sosedoff/pgweb ports: - "8080:8081" environment: - DATABASE_URL=postgres://firstname.lastname@example.org/cassini?sslmode=disable