In order to access data in a PostgreSQL table to view values stored, follow these detailed instructions.
- Open a command prompt to your server. I used Putty.
- switch to a database user with appropriate privileges. I switched to postgres user with: su postgres and enter your pass. mine starts with a “g”(hint for me:-))
- enter psql with: psql databasename
- at the psql command prompt enter: SELECT * FROM tablename;
That will show you all the data in the table on the command line.