testdb=
Table "test.sample"
Column | Type | Collation | Nullable | Default
-----------+---------+-----------+----------+----------------
id | integer | | |
name | text | | |
address | text | | |
groupname | text | | | '営業部'::text
memo | text | | |
Indexes:
"sample_name_key" UNIQUE CONSTRAINT, btree (name)
testdb=
ALTER TABLE
testdb=
Table "test.sample"
Column | Type | Collation | Nullable | Default
-----------+---------+-----------+----------+----------------
id | integer | | not null |
name | text | | |
address | text | | |
groupname | text | | | '営業部'::text
memo | text | | |
Indexes:
"sample_pkey" PRIMARY KEY, btree (id)
"sample_name_key" UNIQUE CONSTRAINT, btree (name)