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

0 vote137 views1 answer
Save single sql query result boolean spring boot
SQL
-1 vote202 views3 answers
PS5
SQL
0 vote266 views1 answer
Oracle sql alter view add column
SQL
6 votes165 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote196 views1 answer
Select not matching data with join table
SQL
20 votes168 views6 answers
Mysql reset auto increment
SQL
2 votes175 views1 answer
Sql skip the first row
SQL
1 vote174 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote163 views1 answer
Drop unique
SQL
0 vote145 views1 answer
Stuff in sql server
SQL