List view

• Add column to tables that tracks datetime when edited most recently, last_updated_time

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Add default values for columns

  e.g. in mailing_list - country defaults to USA - add_date defaults to NOW() / today - modification_date defaults to NOW() / today

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Perform backup and restore

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Scheduled backups in place and confirmed occuring

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• All data from Lotus Approach is in postgres

  No due date
  0% complete0 open0 closed

• All tables from Lotus Approach are in postgres

  No due date
  0% complete0 open0 closed

• Print labels (possibly using CSV and merge)

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Tom executes SQL query

  No due date
  0% complete0 open0 closed

• Tom views data in tables

  No due date
  0% complete0 open0 closed

• Mary views data in tables

  No due date
  0% complete0 open0 closed

• Connect to postgres database from a computer different from the computer that hosts the database

  No due date

  •0/1 issues closed
  0% complete1 open0 closed

• TablePlus -- use GUI to add new row to table and commit change, query contents of table

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• TablePlus -- connect to postgres instance, see database and tables

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• For a table in Lotus Approach, use exported CSV to import into postgres table

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• For a table in Lotus Approach export CSV

  No due date
  0% complete0 open0 closed

• Create table in postgres, which table will contain data from table in Lotus Approach

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Copy data into table in postgres from CSV

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Add data to table in postgres via SQL

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Create table in postgres

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Create database in postgres

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• Make new user -- non-admin user

  No due date

  •0/1 issues closed
  0% complete1 open0 closed

• Make password for admin user

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• install TablePlus

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• log in to postgres instance

  No due date

  •1/1 issues closed
  100% complete0 open1 closed

• postgres instance running on the production server

  No due date

  •0/2 issues closed
  0% complete2 open0 closed

• postgres instance running on one of Michael's computers

  No due date

  •1/1 issues closed
  100% complete0 open1 closed