· 5 years ago · Aug 05, 2020, 03:38 AM
1client.connect()
2 .then(() => client.query(`
3 CREATE TABLE IF NOT EXISTS ${TABLENAME}(
4 "name" TEXT NOT NULL,
5 "post" TEXT NOT NULL
6 )
7 `))
8 .then(() => client.query(`
9 INSERT INTO ${TABLENAME}(${NAMECOLUMNNAME}, ${POSTCOLUMNNAME}) VALUES (${req.query.name}, ${req.query.post})
10 `))
11 .then((r) => (res.send(r)))
12 .catch((e) => res.send(e))
13 .finally(() => client.end())