Build a Json file for tables DDL

Need to generate a Json file of a structure (provided in the project) in Python. The content of Json file will be the DDL of the tables.

Create Two tables in Postgres DB:

[login to view URL](Col1 int, Col2 varchar(256),Col3 varchar(256),Col4 varchar(256))

[login to view URL](Col1 int, Col2 varchar(256),Col3 varchar(256))


select table_schema,table_name, column_name,ordinal_position,data_type

from [login to view URL]

where table_name in ('table1', 'table2') and table_schema = 'dbo' order by 2,3

Take the result of query (executed in python against postgres db), and create the json file (attached in the project)

Compétences : Python, MySQL, PostgreSQL

En voir plus : want can build exe file, need generate traffic website, build hlp file, jquery remote json file, build json mysql, build exe file source code linux, build xml file using crystal, generate report json file pdf, generate html json file, i need a powerpoint presentation and the content, Hi, I have many ex4 file compiled from MT4 build 600+ . I have only build 509 decompiler. So, i need decompile ex4 to mq4 buil, python generate json file from csv, which of the following commands is a quicker way to generate a package.json file?, file could not be uploaded download the latest version of offline tool to generate the json file, how to generate json file using php, how to generate angular.json file

Concernant l'employeur :
( 0 commentaires ) Lucknow, India

Nº du projet : #30109296

Décerné à:


Hello, This can be done using the psycopg2 module. I have experience working with JSON data in python and performing CRUD operations using psycopg2 on PostgreSQL DBs. Please do reach out if you're interested. Thank y Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% INR en 1 jour
(0 Commentaires)

5 freelances font une offre moyenne de 6522 ₹ pour ce travail


Hi I am professional python developer having experience of more than 4 years, I can write the relevant python script that will execute database query mentioned and convert the result into JSON file. Ping me for more Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(22 Commentaires)

Hi, I have 10 years of experience in software development. I can do this job. Hope we can chat Regards, Nagaraja Devadiga

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(9 Commentaires)

Hi, I am available to work on this project if you like you can discus with me in private message I start work asap.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(9 Commentaires)

i am expert in database management, and having 20 years of experience, I could do this effectively and successfully

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)