Insert only an ID: only one column : Insert « Insert Delete Update « PostgreSQL






Insert only an ID: only one column


postgres=#
postgres=# CREATE TABLE employee (
postgres(#     ID         int,
postgres(#     name       varchar(10),
postgres(#     salary     real,
postgres(#     start_date date,
postgres(#     city       varchar(10),
postgres(#     region     char(1)
postgres(# );
CREATE TABLE
postgres=#
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (1,  'Jason', 40420,  '02/01/94', 'New York', 'W');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (2,  'Robert',14420,  '01/02/95', 'Vancouver','N');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (3,  'Celia', 24020,  '12/03/96', 'Toronto',  'W');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (4,  'Linda', 40620,  '11/04/97', 'New York', 'N');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (5,  'David', 80026,  '10/05/98', 'Vancouver','W');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (6,  'James', 70060,  '09/06/99', 'Toronto',  'N');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (7,  'Alison',90620,  '08/07/00', 'New York', 'W');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (8,  'Chris', 26020,  '07/08/01', 'Vancouver','N');
INSERT 0 1
postgres=# insert into employee (ID, name,    salary, start_date, city,       region)
postgres-#               values (9,  'Mary',  60020,  '06/09/02', 'Toronto',  'W');
INSERT 0 1
postgres=#
postgres=# select * from employee;
 id |  name  | salary | start_date |   city    | region
----+--------+--------+------------+-----------+--------
  1 | Jason  |  40420 | 1994-02-01 | New York  | W
  2 | Robert |  14420 | 1995-01-02 | Vancouver | N
  3 | Celia  |  24020 | 1996-12-03 | Toronto   | W
  4 | Linda  |  40620 | 1997-11-04 | New York  | N
  5 | David  |  80026 | 1998-10-05 | Vancouver | W
  6 | James  |  70060 | 1999-09-06 | Toronto   | N
  7 | Alison |  90620 | 2000-08-07 | New York  | W
  8 | Chris  |  26020 | 2001-07-08 | Vancouver | N
  9 | Mary   |  60020 | 2002-06-09 | Toronto   | W
(9 rows)

postgres=#
postgres=# -- Insert only an ID
postgres=#
postgres=# INSERT INTO employee (id) VALUES (108);
INSERT 0 1
postgres=#
postgres=# select * from employee;
 id  |  name  | salary | start_date |   city    | region
-----+--------+--------+------------+-----------+--------
   1 | Jason  |  40420 | 1994-02-01 | New York  | W
   2 | Robert |  14420 | 1995-01-02 | Vancouver | N
   3 | Celia  |  24020 | 1996-12-03 | Toronto   | W
   4 | Linda  |  40620 | 1997-11-04 | New York  | N
   5 | David  |  80026 | 1998-10-05 | Vancouver | W
   6 | James  |  70060 | 1999-09-06 | Toronto   | N
   7 | Alison |  90620 | 2000-08-07 | New York  | W
   8 | Chris  |  26020 | 2001-07-08 | Vancouver | N
   9 | Mary   |  60020 | 2002-06-09 | Toronto   | W
 108 |        |        |            |           |
(10 rows)

postgres=#
postgres=# drop table employee;
DROP TABLE
postgres=#
postgres=#
           
       








Related examples in the same category

1.The data values are listed in the order in which the columns appear in the table, separated by commas
2.List the columns explicitly
3.Omit values
4.Fill the columns from the left with as many values as are given, and the rest will be defaulted
5.Request default values explicitly, for individual columns
6.Request default values explicitly for the entire row
7.Insert date data to table
8.Inserts a single row into the employees table