/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

4 votes292 views2 answers
Convert utc to est sql
SQL
0 vote273 views1 answer
Pl sql search saurce code
SQL
0 vote288 views1 answer
Sql_inner_join
SQL
0 vote309 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote279 views1 answer
How to query all tables mysql at the same time
SQL
0 vote289 views1 answer
How to find username and password in oracle 18c
SQL
0 vote287 views2 answers
Insert into
SQL
1 vote486 views3 answers
Sql subquery
SQL
0 vote299 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
5 votes266 views3 answers
Truncate function in sql oracle
SQL

Share