Mega Code Archive

 

Categories / PostgreSQL / Insert Delete Update

 

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=#