Postgresのpsqlコンソールでテーブル定義を確認するには、\d コマンドを使います。
\d のあとにテーブル名を指定します。
postgres=# \d users;
Table "public.users"
Column | Type | Collation | Nullable | Default
------------------------+-----------------------------+-----------+----------+-----------------------------------
id | bigint | | not null | nextval('users_id_seq'::regclass)
email | character varying | | not null | ''::character varying
encrypted_password | character varying | | not null | ''::character varying
reset_password_token | character varying | | |
reset_password_sent_at | timestamp without time zone | | |
remember_created_at | timestamp without time zone | | |
sign_in_count | integer | | not null | 0
current_sign_in_at | timestamp without time zone | | |
last_sign_in_at | timestamp without time zone | | |
current_sign_in_ip | inet | | |
last_sign_in_ip | inet | | |
confirmation_token | character varying | | |
confirmed_at | timestamp without time zone | | |
confirmation_sent_at | timestamp without time zone | | |
unconfirmed_email | character varying | | |
failed_attempts | integer | | not null | 0
unlock_token | character varying | | |
locked_at | timestamp without time zone | | |
created_at | timestamp without time zone | | not null |
updated_at | timestamp without time zone | | not null |
provider | character varying | | |
uid | character varying | | |
username | character varying | | |
Indexes:
"users_pkey" PRIMARY KEY, btree (id)
"index_users_on_confirmation_token" UNIQUE, btree (confirmation_token)
"index_users_on_email" UNIQUE, btree (email)
"index_users_on_reset_password_token" UNIQUE, btree (reset_password_token)
"index_users_on_unlock_token" UNIQUE, btree (unlock_token)
以上です。