Basic syntax of INSERT INTO statement is as follows. One can insert a single row at a time or several rows as a result of a query. Use LIMIT to specify top 20 rows, but I think you need to sort them using ORDER BY clause first. The PostgreSQL INSERT INTO statement allows one to insert new rows into a table. I don't like that nested dblink, but AFAIK I can't reference to tblB in dblink_exec body. The convention for the naming of the column names here is like column11 and column21 means column1 of table1 and. table2 is the name of the table from where you want to populate data. Use the INSERT INTO command in conjunction with a SELECT statement to insert. If my understanding is correct (postgres has tbla and dbtest has tblb and you want remote insert with local select, not remote select with local insert as above): psql dbtest PostgreSQL INSERT INTO table from SELECT query table1 is the name of the table where you want to populate data. Use the INSERT INTO command with a grouped set of data to insert new values. I just saw your revised question (closed as duplicate, or just very similar to this). You can make it as prepared statement if you want and it works as well: PREPARE migrate_data (integer) AS PostgreSQL has record pseudo-type (only for function's argument or result type), which allows you query data from another (unknown) table. INSERT INTO tblB (time) VALUES (5000), (2000) ĬREATE TABLE tblA (id serial, time integer) įROM dblink('dbname=dbtest', 'SELECT id, time FROM tblB') For example: psql dbtestĬREATE TABLE tblB (id serial, time integer) As Henrik wrote you can use dblink to connect remote database and fetch result.

Postgresql insert into table