/SQL/PostgreSQL add column

PostgreSQL add 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

Alter table add multiple columns postgresql

        
            
        
     ALTER TABLE customer 
ADD COLUMN fax VARCHAR,
ADD COLUMN email VARCHAR;

3

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

1 vote351 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote371 views1 answer
Top 3 salary in sql
SQL
-1 vote339 views1 answer
Count occurrences sql
SQL
1 vote389 views2 answers
Postgresql check privileges on schema
SQL
0 vote360 views1 answer
Flexible search query delete table
SQL
0 vote392 views1 answer
Update top 100 order by sql server
SQL
6 votes348 views2 answers
Where clause in sql
SQL
11 votes382 views2 answers
Mysql disable safe mode
SQL
-1 vote339 views3 answers
Create temp table in sql
SQL
2 votes369 views1 answer
Mysql set value as null
SQL

Share