There are a variety of options to interact with your PostgreSQL instance:
- DBeaver Community Edition can be downloaded from here. It is a locally installed, graphical tool that lets you connect to a variety of database systems, including PostgreSQL with very extensive documentation wiki.
psql: the command-line tool for text-based interactions with PostgreSQL, this should come with your PostgreSQL installation