Insert Delete Update PostgreSQL

  1. Home
  2. PostgreSQL
  3. Insert Delete Update
  4. 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=#