>> create table foobar ( foo int primary key, bar int ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foobar_pkey" for table "foobar" CREATE TABLE
>> \d foobar Table "public.foobar" Column | Type | Modifiers --------+---------+----------- foo | integer | not null bar | integer | Indexes: "foobar_pkey" PRIMARY KEY, btree (foo)