· 8 years ago · Jul 16, 2018, 10:46 PM
1CREATE TABLE IF NOT EXISTS xter (id serial not null, ip varchar(32), uid varchar(128), psr varchar(255), username varchar(128));
2CREATE UNIQUE INDEX ON xter (uid);
3
4INSERT INTO xter (ip, uid, psr, username) VALUES ($1, $2, $3, $4) ON CONFLICT (uid) DO UPDATE SET ip = ($5), uid = ($6), psr = ($7), username = ($8) WHERE uid = EXCLUDED.uid;