defines a table and commands for use with postgres