sql - 在 SQL 查询中使用表中的值

Question

给定三个 SQL 表，
PEOPLE 列 - name (varchar), age (integer)
INFO 包含列 - email (varchar)、phone (varchar)
还有一个 master_table 作为 -

ID  |  TABLENAME     | RECORD  
--- | -------------- | ------------------------------------------------------------------  
1   |      PEOPLE    | "{"name": "Mary", "age": 12}"  
2   |      INFO      | "{"email": "xyz@abc.com", "phone": "321-456"}"  

现在，我想编写一个查询，将数据从 master_table 加载到相应的表中。一些关于-

INSERT INTO @TABLENAME VALUES @RECORD AS JSON 'AUTO'  

其中，@TABLENAME 是说，SELECT TABLENAME FROM MASTER_TABLE WHERE ID=1
并且 @RECORD 是 SELECT RECORD FROM MASTER_TABLE WHERE ID=1

如何实现这一目标？

Answer 1

像这样:

insert into people (name, age)
select record::json ->> 'name', (record::json ->> 'age')::int
from master_table
where tablename = 'PEOPLE';

insert into info (email, phone)
select record::json ->> 'email', record::json ->> 'phone'
from master_table
where tablename = 'INFO';