Postgresql create query

CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL,
   JOIN_DATE	  DATE
);

INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (1, 'Paul', 32, 'California', 20000.00,'2001-07-13');
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,JOIN_DATE) VALUES (2, 'Allen', 25, 'Texas', '2007-12-13');
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (3, 'Teddy', 23, 'Norway', 20000.00, DEFAULT );
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00, '2007-12-13' ), (5, 'David', 27, 'Texas', 85000.00, '2007-12-13');

Source: tutorialspoint.com

Similar codes

1 vote143 views1 answer
How to find median of a column sql
SQL
1 vote166 views3 answers
Connection string mysql
SQL
2 votes147 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
1 vote142 views3 answers
Getdate function in postgresql
SQL
0 vote170 views1 answer
Get only structure database mysql
SQL
0 vote153 views1 answer
Sql search all columns of database oracle sql
SQL
11 votes142 views5 answers
Laravel db facade
SQL
0 vote169 views1 answer
Select new table sql
SQL
13 votes143 views5 answers
Oracle list tables
SQL
0 vote233 views1 answer
Add user mysql wordpress
SQL