Use Psql to test database connection after install

Postgresql

Note:  command case sensitive.  Issued from shell at <install directory>/bin

      • psql -d mydb -U myuser
      • To change database: 
        \c databasename
      • For a list of databases and charset properties: 
        \l
      • For a list of tables in current database: 
        \dt

        You will get a “No relations found” if there are no tables

      • Note: all SQL query has to end in a semicolon.  Otherwise, it won’t execute
      • Note: if you get a conflict of charset error message between utf8 and windows, you must first set the postgres charset to utf8 as follows: 
        SET CLIENT_ENCODING TO 'utf8';