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)
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
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
Hi, I have 10 years of experience in software development. I can do this job. Hope we can chat Regards, Nagaraja Devadiga
Hi, I am available to work on this project if you like you can discus with me in private message I start work asap.
i am expert in database management, and having 20 years of experience, I could do this effectively and successfully