/SQL/Postgres how to add field created at

Postgres how to add field created at

Postgresql add column with constraint

ALTER TABLE customers 
ADD COLUMN contact_name VARCHAR NOT NULL;

31

Source: postgresqltutorial.com

Postgres how to add field created at

CREATE TABLE my_table
(
	id serial NOT NULL,
    user_name text,
	created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP //here
)

2

Similar codes

0 vote349 views1 answer
Psql check if sql script is valid
SQL
0 vote301 views1 answer
Postgresql not in alternative
SQL
0 vote335 views1 answer
PGSQL dynamic table name
SQL
0 vote285 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote300 views7 answers
Les jointures sql server
SQL
0 vote335 views1 answer
Sqlite trim
SQL
0 vote269 views1 answer
Duplicate foreign key constraint name
SQL
0 vote290 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote309 views1 answer
Mysql root permission denied lost
SQL
0 vote295 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL

Share