createdb image_upload psql image_upload CREATE TABLE image_files( id SERIAL NOT NULL PRIMARY KEY, filename TEXT UNIQUE NOT NULL, filepath TEXT NOT NULL, mimetype TEXT NOT NULL, size BIGINT NOT null, ) ...

This is both a brief tutorial and a quick reference for the absolute least you need to know about psql. I assume you're familiar with the command line and have a rough idea about what database ...