/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

0 vote174 views1 answer
Python mysql query where
SQL
1 vote421 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
14 votes227 views1 answer
Excel is not a database
SQL
1 vote188 views3 answers
Epoch to datetime
SQL
0 vote184 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote189 views1 answer
Modifier une valeur sql
SQL
0 vote179 views1 answer
Copy Table from SQL to CSV
SQL
1 vote176 views1 answer
Postgres set column equal to another
SQL
0 vote182 views1 answer
What is ssrs and ssis in sql server
SQL
8 votes173 views1 answer
Oracle add months to sysdate
SQL

Share