Anonymous user
Table creation: Difference between revisions
→[[PostgreSQL]]
Line 4:
==[[PostgreSQL]]==
Postgres developers, please feel free to add additional fields you commonly use to this example.
-- This is a comment
Line 23 ⟶ 25:
note text not null,
unique(account_id, note)
);
-- bool: 't', 'f' or NULL
-- int2: -32768 to +32767
-- int4: -2147483648 to +2147483647
-- float: decimal
-- date: obvious
-- timestamp: date time
-- char(#): space padded text field with length of #
-- varchar(#): variable length text field up to #
-- text: not limited
| |||