'Python with JSON Create Table SQL

I have 2 list

c_name = ['departmentid', 'name', 'groupname', 'modifieddate']
d_type =['integer', 'character varying', 'character varying', 'timestamp without time zone']

And I would like to create a SQL query for creating a tables

CREATE TABLE MY_TABLE(
  'departmentid' 'integer',
  'name' 'character varying',
  'groupname' 'character varying',
  'modifieddate' 'timestamp without time zone'
);

Thank you for your help

python json

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Python with JSON Create Table SQL

Sources

Related Questions