Creating default UUID generator in postgres

Question

Could anyone help on how to create a column with uuid generator field which would generate random numbers automatically while inserting the row.

Answer 1

If you install the uuid-ossp extension, you can e.g. use uuid_generate_v4() for the default value of such a column:

create table selva
(
  uid uuid default uuid_generate_v4(),
  ... other columns ..
);