/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

1 vote320 views2 answers
Group_concat limit mysql
SQL
1 vote306 views1 answer
Postgresql delete cascade
SQL
8 votes306 views1 answer
Oracle tablespace datafile max size
SQL
3 votes318 views2 answers
MySQL query to get column names
SQL
2 votes323 views1 answer
Oracle trace file
SQL
0 vote326 views1 answer
Sql column contains special character
SQL
0 vote310 views1 answer
Oracle execute package dblink
SQL
0 vote316 views1 answer
Create table database in psql
SQL
0 vote306 views1 answer
Mysql select statement after index
SQL
0 vote296 views1 answer
Left join in codeigniter query builder
SQL

Share