gistfile1.txt

[ken@kb puppetdb]# psql
psql (9.3.4)
Type "help" for help.

ken=# \c puppetdb
You are now connected to database "puppetdb" as user "ken".
puppetdb=# select * from schema_migrations;
 version |          time
---------+-------------------------
       1 | 2014-04-18 18:15:20.853
       2 | 2014-04-18 18:15:20.857
       3 | 2014-04-18 18:15:20.858
       4 | 2014-04-18 18:15:20.89
       5 | 2014-04-18 18:15:20.895
       6 | 2014-04-18 18:15:20.897
       7 | 2014-04-18 18:15:20.901
       8 | 2014-04-18 18:15:20.902
       9 | 2014-04-18 18:15:20.926
      10 | 2014-04-18 18:15:20.929
      11 | 2014-04-18 18:15:20.931
      12 | 2014-04-18 18:15:20.953
      13 | 2014-04-18 18:15:20.961
      14 | 2014-04-18 18:15:20.973
      15 | 2014-04-18 18:15:20.975
      16 | 2014-04-18 18:15:20.975
      17 | 2014-04-18 18:15:21.026
      18 | 2014-04-18 18:15:21.029
      19 | 2014-04-18 18:15:21.039
      20 | 2014-04-18 18:15:21.055
      21 | 2014-04-18 18:15:21.058
      22 | 2014-04-18 18:15:21.069
(22 rows)

puppetdb=#
puppetdb=# \dt
                  List of relations
 Schema |          Name           | Type  |  Owner
--------+-------------------------+-------+----------
 public | catalog_resources       | table | puppetdb
 public | catalogs                | table | puppetdb
 public | certname_facts          | table | puppetdb
 public | certname_facts_metadata | table | puppetdb
 public | certnames               | table | puppetdb
 public | edges                   | table | puppetdb
 public | environments            | table | puppetdb
 public | latest_reports          | table | puppetdb
 public | reports                 | table | puppetdb
 public | resource_events         | table | puppetdb
 public | resource_params         | table | puppetdb
 public | resource_params_cache   | table | puppetdb
 public | schema_migrations       | table | puppetdb
(13 rows)