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 vote294 views1 answer
Sql query to get column names and data types in sql server
SQL
2 votes334 views1 answer
Query to check cpu utilization in oracle database
SQL
2 votes324 views2 answers
Spring where to put the data sql
SQL
0 vote264 views1 answer
Create dabase postgresql
SQL
1 vote328 views1 answer
Sql server if exists update else insert
SQL
0 vote332 views1 answer
Creating sqeuence in oracle database
SQL
0 vote302 views1 answer
How to Remove milliseconds from Date time
SQL
-1 vote295 views1 answer
Sql set max value in column
SQL
7 votes299 views2 answers
Oracle foreign key reference table
SQL
0 vote285 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL