which data type should I choose for a unique key (id of a user for example) in postgresql database's table?
does bigint is the one?
serial type for automatically incrementing unique ids.
If you plan to have more than two billion entries, use
serial is the PostgresSQL equivalent of MySQL's