Answers for "insert data from one database table to another database table in postgresql using pgadmin"

POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE

##fetch data from other table with sub-query to insert it into another one

INSERT INTO PUBLIC."MyTable"(conversion_job_id, message, last_status)
VALUES (17, 'test', (SELECT status FROM PUBLIC."OtherTable" WHERE id=17))
RETURNING *

Posted by: Guest on August-10-2021

insert data from one database table to another database table in postgresql using pgadmin

truncate table tableA;

insert into tableA
select *
from dblink('hostaddr=xxx.xxx.xxx.xxx dbname=mydb user=postgres',
            'select a,b from tableA')
       as t1(a text,b text);

Posted by: Guest on March-02-2022

Code answers related to "insert data from one database table to another database table in postgresql using pgadmin"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert data from one database table to another database table in postgresql using pgadmin"

Code answers related to "insert data from one database table to another database table in postgresql using pgadmin"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert data from one database table to another database table in postgresql using pgadmin"

Code answers related to "insert data from one database table to another database table in postgresql using pgadmin"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us