/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 vote157 views1 answer
Truncate table sql server foreign key
SQL
0 vote158 views1 answer
Sql query to select records entered in last 24 hours
SQL
1 vote276 views1 answer
Concat first name and last name in mysql
SQL
0 vote169 views1 answer
SQL isnumeric DB2
SQL
0 vote174 views1 answer
Create user faunadb
SQL
2 votes177 views4 answers
Sql query interview questions
SQL
0 vote178 views1 answer
Import Data in MySQL without using any other software
SQL
3 votes190 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
12 votes214 views6 answers
How to install sqlite3 in python
SQL
2 votes174 views1 answer
How to get weekday from old date in sql
SQL

Share