• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

how to copy and paste entire record between two similar tables in different schemas of same database

Hi,

I need to export and import( or otherwords copy and paste) entire record between two same structured  tables in different schemas ( say table_A is in schema_A and table_B is in schema_B. Table_B supposed to be same  as Table_A both with structure and data but  couple  of records missing which i need to copy from Table_A and paste into table_B)  of same database. What is the quickest way to do it. Any sample code, ideas, resources highly appreciated. Thanks in advance.
0
gudii9
Asked:
gudii9
1 Solution
 
flow01Commented:
insert into schema_b.table_b b
select * from schema_a.table_a a
where not exists (select 1 from  a.id = b.id)
0
 
gudii9Author Commented:
Thank you very much. I appreciate it.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now