The blog has moved to ... Many google searches point here so I am leaving it operational, but there will be no new posts.

Friday, December 2, 2011

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

No comments: