René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Article","@id":"https://pynative.com/python-postgresql-tutorial/#article","isPartOf":{"@id":"https://pynative.com/python-postgresql-tutorial/"},"author":{"name":"Vishal","@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f"},"headline":"Python PostgreSQL Tutorial Using Psycopg2","datePublished":"2018-08-09T07:20:48+00:00","dateModified":"2021-03-09T05:18:04+00:00","mainEntityOfPage":{"@id":"https://pynative.com/python-postgresql-tutorial/"},"wordCount":1797,"commentCount":41,"publisher":{"@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f"},"image":{"@id":"https://pynative.com/python-postgresql-tutorial/#primaryimage"},"thumbnailUrl":"https://pynative.com/wp-content/uploads/2018/08/python_postgresql-1.png","keywords":["Python PostgreSQL"],"articleSection":["Python","Python Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https://pynative.com/python-postgresql-tutorial/#respond"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"WebPage","@id":"https://pynative.com/python-postgresql-tutorial/","url":"https://pynative.com/python-postgresql-tutorial/","name":"Python PostgreSQL Tutorial Using Psycopg2 [Complete Guide]","isPartOf":{"@id":"https://pynative.com/#website"},"primaryImageOfPage":{"@id":"https://pynative.com/python-postgresql-tutorial/#primaryimage"},"image":{"@id":"https://pynative.com/python-postgresql-tutorial/#primaryimage"},"thumbnailUrl":"https://pynative.com/wp-content/uploads/2018/08/python_postgresql-1.png","datePublished":"2018-08-09T07:20:48+00:00","dateModified":"2021-03-09T05:18:04+00:00","description":"Connect to PostgreSQL database from Python using Psycopg2. Select, Insert, update, delete PostgreSQL data from Python. execute stored prodcudure and manage PostgreSQL transction from Python.","breadcrumb":{"@id":"https://pynative.com/python-postgresql-tutorial/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https://pynative.com/python-postgresql-tutorial/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https://pynative.com/python-postgresql-tutorial/#primaryimage","url":"https://pynative.com/wp-content/uploads/2018/08/python_postgresql-1.png","contentUrl":"https://pynative.com/wp-content/uploads/2018/08/python_postgresql-1.png","width":297,"height":231,"caption":"Python PostgreSQL"},{"@type":"BreadcrumbList","@id":"https://pynative.com/python-postgresql-tutorial/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://pynative.com/"},{"@type":"ListItem","position":2,"name":"Python","item":"https://pynative.com/python/"},{"@type":"ListItem","position":3,"name":"Databases","item":"https://pynative.com/python/databases/"},{"@type":"ListItem","position":4,"name":"Python PostgreSQL Tutorial Using Psycopg2"}]},{"@type":"WebSite","@id":"https://pynative.com/#website","url":"https://pynative.com/","name":"PYnative","description":"Python Programming","publisher":{"@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://pynative.com/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f","name":"Vishal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https://pynative.com/#/schema/person/image/","url":"https://pynative.com/wp-content/uploads/2019/01/vishalHule.jpg","contentUrl":"https://pynative.com/wp-content/uploads/2019/01/vishalHule.jpg","width":968,"height":1065,"caption":"Vishal"},"logo":{"@id":"https://pynative.com/#/schema/person/image/"},"description":"Founder of PYnative.com. I am a Python developer and I love to write articles to help developers. | All the best for your future Python endeavors!","sameAs":["https://pynative.com"]},{"@type":"HowTo","@id":"https://pynative.com/python-postgresql-tutorial/#howto-1","name":"Python PostgreSQL Tutorial Using Psycopg2","mainEntityOfPage":{"@id":"https://pynative.com/python-postgresql-tutorial/#article"},"description":"How to Connect to PostgreSQL in Python","step":[{"@type":"HowToStep","url":"https://pynative.com/python-postgresql-tutorial/#how-to-step-1612938393338","name":"Install Psycopg2 module","itemListElement":[{"@type":"HowToDirection","text":"Install and import psycopg2 module. Import using a import psycopg2 statement so you can use this module's methods to communicate with the PostgreSQL database."}]},{"@type":"HowToStep","url":"https://pynative.com/python-postgresql-tutorial/#how-to-step-1612938566138","name":"Use the connect() method","itemListElement":[{"@type":"HowToDirection","text":"Use the psycopg2.connect() method with the required arguments to connect MySQL. It would return an Connection object if the connection established successfully"}]},{"@type":"HowToStep","url":"https://pynative.com/python-postgresql-tutorial/#how-to-step-1612939866983","name":"Use the cursor() method","itemListElement":[{"@type":"HowToDirection","text":"Create a cursor object using the connection object returned by the connect method to execute PostgreSQL queries from Python."}]},{"@type":"HowToStep","url":"https://pynative.com/python-postgresql-tutorial/#how-to-step-1612938641024","name":"Use the execute() method","itemListElement":[{"@type":"HowToDirection","text":"The execute() methods run the SQL query and return the result."}]},{"@type":"HowToStep","url":"https://pynative.com/python-postgresql-tutorial/#how-to-step-1612938710846","name":"Extract result using fetchall()","itemListElement":[{"@type":"HowToDirection","text":"Use cursor.fetchall() or fetchone() or fetchmany() to read query result."}]},{"@type":"HowToStep","url":"https://pynative.com/python-postgresql-tutorial/#how-to-step-1612938784560","name":"Close cursor and connection objects","itemListElement":[{"@type":"HowToDirection","text":"use cursor.clsoe() and connection.clsoe() method to close PostgreSQL connections after your work completes"}]}],"inLanguage":"en-US"}]}