/SQL/Postgresql insert column

Postgresql insert column

Postgresql add column with constraint

ALTER TABLE customers 
ADD COLUMN contact_name VARCHAR NOT NULL;

31

Source: postgresqltutorial.com

Postgresql insert column

ALTER TABLE table_name
ADD COLUMN new_column_name data_type constraint;

4

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 vote335 views1 answer
Error code 1055
SQL
2 votes396 views1 answer
Oracle find constraints referencing a table
SQL
0 vote363 views2 answers
Dumping sql table
SQL
0 vote317 views1 answer
Duplicate foreign key constraint name
SQL
1 vote344 views1 answer
Mysql copy table1 to table2
SQL
8 votes387 views2 answers
How to fetch data from database without last column
SQL
27 votes359 views6 answers
Set password mysql
SQL
0 vote350 views1 answer
Sqlite update only if greater
SQL
6 votes352 views2 answers
Clear a table in mysql
SQL
0 vote401 views2 answers
Clauses in mysql
SQL

Share