INSERT INTO vv SELECT 'abc' || 'def' : Insert Select « Insert Delete Update « PostgreSQL






  1. PostgreSQL
  2. Insert Delete Update
  3. Insert Select

INSERT INTO vv SELECT 'abc' || 'def'


postgres=#
postgres=# CREATE TABLE vv (v character(20));
CREATE TABLE
postgres=#
postgres=# INSERT INTO vv SELECT 'abc' || 'def';
INSERT 0 1
postgres=# SELECT v, length(v) FROM vv;
          v           | length
----------------------+--------
 abcdef               |      6
(1 row)

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








Related examples in the same category

1.Restructuring a table with CREATE TABLE and INSERT INTO
2.Insert into by select statement