random code and what not

Get table and column information in postgres

Use the information_schema catalog -

Get table and columns from the public schema

This can be useful, maybe you want to auto generate some text that creates foreign keys based on a naming convention - for instance let’s say we have a ruby/rails method called make_fk_unless_exists

The ‘code’ column would render something like

make_fk_unless_exists :projects, :milestone_id, :milestones
make_fk_unless_exists :tasks, :project_id, :projects