· 8 years ago · Apr 20, 2018, 07:00 AM
1CREATE TABLE IF NOT EXISTS users ( 2 id SERIAL NOT NULL, 3 name VARCHAR(512) NOT NULL, 4 PRIMARY KEY (id)); 5 6CREATE INDEX users_name_idx ON users (lower(name::varchar(16)));