A crash course in PostgreSQL, Part 1

02.09.2011

"pg_am_name_index" UNIQUE, btree (amname)

"pg_am_oid_index" UNIQUE, btree (oid)

This is just the table structure without data. It shows the column names, the data type for each column, and any optional modifiers. Try creating your own table in your test database. For instance, this simple table tracks my underground comics collection:

CREATE TABLE comics (

name varchar(80),