The relevant command-line utilities are createdb and dropdb. Load data into a PostgreSQL database Database design is an art, not a science, and takes considerable experience to get right.

If you use the SQL command line to mine the records in your tables, you’ll discover that a JOIN may be the best tool for finding the information you need. This week, I’ll explain the basic ...