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=#
1. | Restructuring a table with CREATE TABLE and INSERT INTO | ||
2. | Insert into by select statement |