Gist will create towns table and will insert 100k records in towns table using generate_series

create_multiple_records.sql

CREATE TABLE towns (
  id SERIAL UNIQUE NOT NULL,
  code VARCHAR(10) NOT NULL, -- not unique
  article TEXT,
  name TEXT NOT NULL -- not unique
);

insert into towns (
    code, article, name
)
select
    left(md5(i::text), 10),
    md5(random()::text),
    md5(random()::text)
from generate_series(1, 100000) s(i)