Use Psql to test database connection after install

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:
      • For a list of tables in current database:

        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';