psvjMSh8

1drop table if exists users;
2create table users (
3  id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
4  name varchar,
5  email varchar,
6  username varchar,
7  password varchar,
8  register_date CURRENT_TIMESTAMP() not null
9);
10	
11cur.execute("INSERT INTO users(name, email, username, password) VALUES(%s, %s, %s, %s)", (name, email, username, password))
12	
13ERROR:  syntax error at or near "CURRENT_TIMESTAMP"
14LINE 7:   register_date CURRENT_TIMESTAMP() not null
15	
16create table users (
17  id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
18  name varchar,
19  email varchar,
20  username varchar,
21  password varchar,
22  register_date TIMESTAMP DEFAULT NOW()
23);
24	
25INSERT INTO users(name, email, username, password)
26VALUES('Foo', 'foo@bar.com', 'bar', 'foobar')
27	
28create table users (
29  id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
30  name varchar,
31  email varchar,
32  username varchar,
33  password varchar,
34  register_date timestamp default CURRENT_TIMESTAMP not null
35);
36	
37insert into users(name, email, username, password)
38values('n', 'e@e.com', 'un', 'pwd');