/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

2 votes45 views2 answers
Sql strip non alphanumeric characters
SQL
23 votes53 views1 answer
How remove column in mysql
SQL
1 vote51 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote50 views1 answer
Oracle temporary table
SQL
0 vote46 views1 answer
Postgresql create table default value timestamp
SQL
21 votes15 views7 answers
Table drop if exist sql server
SQL
0 vote49 views1 answer
Oracle show running job
SQL
5 votes43 views1 answer
Sql asynchronous stored procedure call
SQL
3 votes47 views1 answer
Sql server check version
SQL
0 vote44 views1 answer
Sqlalchemy query return only n results
SQL

Share