You can either use psql command line tool and use PostgreSQL commands and SQL in it, or you can install some graphical tool, whatever you prefer.
The official graphical PostgreSQL tool is named pgAdmin3 if I recall correctly.
6 Likes
