{"id":179,"date":"2022-06-05T23:26:30","date_gmt":"2022-06-05T14:26:30","guid":{"rendered":"https:\/\/www.bees-team.com\/?p=179"},"modified":"2022-06-06T22:27:42","modified_gmt":"2022-06-06T13:27:42","slug":"newbie-python-postgresql-ket-noi-voi-co-so-du-lieu-postgresql-bang-ngon-ngu-python","status":"publish","type":"post","link":"https:\/\/www.bees-team.com\/?p=179","title":{"rendered":"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python."},"content":{"rendered":"<div class=\"post-content\"><div class='booster-block booster-read-block'>\n                <div class=\"twp-read-time\">\n                \t<i class=\"booster-icon twp-clock\"><\/i> <span>Read Time:<\/span>1 Minute, 49 Second                <\/div>\n\n            <\/div><div class=\"post-body\">\n<h2>M\u1ee5c l\u1ee5c<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.bees-team.com\/?p=179#ta-toc-1\">Install Driver d\u00f9ng \u0111\u1ec3 k\u1ebft n\u1ed1i v\u1edbi PostgreSQL<\/a><\/li>\n<li><a href=\"https:\/\/www.bees-team.com\/?p=179#ta-toc-2\">C\u00e1ch vi\u1ebft code Python \u0111\u1ec3 k\u1ebft n\u1ed1i v\u1edbi PostgreSQL<\/a><\/li>\n<li><a href=\"https:\/\/www.bees-team.com\/?p=179#ta-toc-3\">Th\u1ef1c thi m\u1ed9t c\u00e2u l\u1ec7nh SQL \u0111\u01a1n gi\u1ea3n.<\/a><\/li>\n<\/ul>\n<div class=\"code-block code-block-1\"><\/div>\n<div class=\"voice\">\n<div class=\"voice-text-left\">\n<h2><span id=\"ta-toc-1\">Install Driver d\u00f9ng \u0111\u1ec3 k\u1ebft n\u1ed1i v\u1edbi PostgreSQL<\/span><\/h2>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 k\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng python , ta d\u00f9ng psycopg2.<\/p>\n<p>\u0110\u1ec3 install psycopg2 ta th\u1ef1c thi c\u00e2u l\u00eanh b\u00ean d\u01b0\u1edbi.<\/p>\n<p>H\u1ec7 \u0111i\u1ec1u h\u00e0nh Mac ,Windows ho\u1eb7c l\u00e0 linux ta \u0111i\u1ec1u c\u00f3 th\u1ec3 install b\u1eb1ng command.<\/p>\n<pre>pip install psycopg2<\/pre>\n<p>N\u1ebfu version c\u1ee7a Python l\u00e0 3.x th\u00ec d\u00f9ng c\u00e2u l\u1ec7nh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<pre>pip3 install psycopg2<\/pre>\n<p>&nbsp;<\/p>\n<h2><span id=\"ta-toc-2\">C\u00e1ch vi\u1ebft code Python \u0111\u1ec3 n\u1ed1i k\u1ebft v\u1edbi d\u01a1 s\u1edf d\u1eef li\u1ec7u PostgreSQL.<\/span><\/h2>\n<p>\u0110\u1ec3 k\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL ta vi\u1ebft code nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<pre>import psycopg2\r\n\r\n# T\u1ea1o k\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL\r\n conn = psycopg2.connect(\r\n            host = '172.0.0.1',\r\n            port = 5432,\r\n            database='test_postgre_sql',\r\n            user='admin',\r\n            password='xxxxxxxxx')\r\n\r\n# \u0110\u00f3ng k\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u PostgreSQL\r\n conn.close<\/pre>\n<ul>\n<li>host\uff1aCh\u1ec9 \u0111\u1ecbnh host ho\u1eb7c l\u00e0 IP c\u1ee7a server PostgreSQL<\/li>\n<li>port\uff1aCh\u1ec9 \u0111\u1ecbnh port cho connect.<\/li>\n<li>database : Ch\u1ec9 \u0111\u1ecbnh c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ea7n k\u1ebft n\u1ed1i<\/li>\n<li>\u00a0user\uff1auser id<\/li>\n<li>password\uff1apassword.<\/li>\n<\/ul>\n<h2><span id=\"ta-toc-3\">Th\u1eed th\u1ef1c thi m\u1ed9t c\u00e2u l\u1ec7nh SQL \u0111\u01a1n gi\u1ea3n.<\/span><\/h2>\n<p>Th\u1eed vi\u1ebft m\u1ed9t \u0111o\u1ea1n code Python \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 thao t\u00e1c tr\u00ean c\u01a1 s\u1edf d\u1eef li\u1ec7u PostgreSQL.<\/p>\n<p>\u1ede \u0111o\u1ea1n code n\u00e0y ta s\u1ebd k\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1ee1 d\u1eef li\u1ec7u PostgreSQL v\u00e0 th\u1ef1c thi c\u00e2u l\u00eanh select \u0111\u1ec3 l\u1ea5y data t\u1eeb hai c\u1ed9t host v\u00e0 user c\u1ee7a b\u1ea3ng user.<\/p>\n<h3>Source Code<\/h3>\n<pre>import psycopg2\r\n\r\n# T\u1ea1o k\u1ebft n\u1ed1i v\u1edbi PostgreSQL\r\n conn = psycopg2.connect(\r\n            host = '172.0.0.1',\r\n            port = 5432,\r\n            database='test_postgre_sql',\r\n            user='admin',\r\n            password='xxxxxxxxx')\r\n\r\n# T\u1ea1o con tr\u1ecf \u0111\u1ec3 tr\u1ecf v\u00e0o C\u01a1 s\u1edf d\u1eef li\u1ec7u.\r\n cur = conn.cursor()\r\n\r\n# Th\u1ef1c thi c\u00e2u l\u1ec7nh SQL\r\n# L\u1ea5y Host v\u00e0 User t\u1eeb b\u1ea3ng user\r\n sql = \"select Host, User from user\"\r\n cur.execute(sql)\r\n\r\n# L\u1ea5y k\u1ebft qu\u1ea3 khi th\u1ef1c thi c\u00e2u l\u1ec7nh sql\r\n rows = cur.fetchall()\r\n\r\n# Hi\u1ec3n th\u1ecb t\u1eebng d\u00f2ng d\u1eef li\u1ec7u.\r\n for row in rows:\r\n  print(row)\r\n\r\n cur.close\r\n conn.close<\/pre>\n<p>&nbsp;<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 khi ch\u1ea1y \u0111o\u1ea1n code tr\u00ean.<\/p>\n<pre>('127.0.0.1', 'root')\r\n('::1', 'root')\r\n('localhost', 'pma')\r\n('localhost', 'root')<\/pre>\n<p>&nbsp;<\/p>\n<\/div>\n        <div class=\"booster-block booster-reactions-block\">\n            <div class=\"twp-reactions-icons\">\n                \n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-1\" post-id=\"179\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.bees-team.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/happy.svg\" alt=\"Happy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Happy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-2\" post-id=\"179\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.bees-team.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sad.svg\" alt=\"Sad\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sad                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-3\" post-id=\"179\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.bees-team.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/excited.svg\" alt=\"Excited\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Excited                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-6\" post-id=\"179\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.bees-team.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sleepy.svg\" alt=\"Sleepy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sleepy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-4\" post-id=\"179\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.bees-team.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/angry.svg\" alt=\"Angry\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Angry<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                        \n                    <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-5\" post-id=\"179\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.bees-team.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/surprise.svg\" alt=\"Surprise\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Surprise<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n            <\/div>\n        <\/div>\n\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>M\u1ee5c l\u1ee5c Install Driver d\u00f9ng \u0111\u1ec3 k\u1ebft n\u1ed1i v\u1edbi PostgreSQL<a href=\"https:\/\/www.bees-team.com\/?p=179\">Read More<i class=\"fa fa-long-arrow-right\" aria-hidden=\"true\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-experiment-about-python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python. - Experiment Log<\/title>\n<meta name=\"description\" content=\"PostgreSQL python\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python. - Experiment Log\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL python\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bees-team.com\/?p=179\" \/>\n<meta property=\"og:site_name\" content=\"Experiment Log\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-05T14:26:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-06T13:27:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/06\/Python-PostgreSQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"696\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bees-Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bees-Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179\"},\"author\":{\"name\":\"Bees-Team\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#\\\/schema\\\/person\\\/974321230684f994b6f3a28aa132b197\"},\"headline\":\"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python.\",\"datePublished\":\"2022-06-05T14:26:30+00:00\",\"dateModified\":\"2022-06-06T13:27:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179\"},\"wordCount\":319,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Python-PostgreSQL.jpg\",\"articleSection\":[\"Python Advance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.bees-team.com\\\/?p=179#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179\",\"url\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179\",\"name\":\"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python. - Experiment Log\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Python-PostgreSQL.jpg\",\"datePublished\":\"2022-06-05T14:26:30+00:00\",\"dateModified\":\"2022-06-06T13:27:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#\\\/schema\\\/person\\\/974321230684f994b6f3a28aa132b197\"},\"description\":\"PostgreSQL python\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bees-team.com\\\/?p=179\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#primaryimage\",\"url\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Python-PostgreSQL.jpg\",\"contentUrl\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Python-PostgreSQL.jpg\",\"width\":696,\"height\":410},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=179#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bees-team.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#website\",\"url\":\"https:\\\/\\\/www.bees-team.com\\\/\",\"name\":\"Experiment Log\",\"description\":\"Just note what I did\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bees-team.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#\\\/schema\\\/person\\\/974321230684f994b6f3a28aa132b197\",\"name\":\"Bees-Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g\",\"caption\":\"Bees-Team\"},\"sameAs\":[\"https:\\\/\\\/www.bees-team.com\\\/\"],\"url\":\"https:\\\/\\\/www.bees-team.com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python. - Experiment Log","description":"PostgreSQL python","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python. - Experiment Log","og_description":"PostgreSQL python","og_url":"https:\/\/www.bees-team.com\/?p=179","og_site_name":"Experiment Log","article_published_time":"2022-06-05T14:26:30+00:00","article_modified_time":"2022-06-06T13:27:42+00:00","og_image":[{"width":696,"height":410,"url":"http:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/06\/Python-PostgreSQL.jpg","type":"image\/jpeg"}],"author":"Bees-Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bees-Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bees-team.com\/?p=179#article","isPartOf":{"@id":"https:\/\/www.bees-team.com\/?p=179"},"author":{"name":"Bees-Team","@id":"https:\/\/www.bees-team.com\/#\/schema\/person\/974321230684f994b6f3a28aa132b197"},"headline":"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python.","datePublished":"2022-06-05T14:26:30+00:00","dateModified":"2022-06-06T13:27:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bees-team.com\/?p=179"},"wordCount":319,"commentCount":0,"image":{"@id":"https:\/\/www.bees-team.com\/?p=179#primaryimage"},"thumbnailUrl":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/06\/Python-PostgreSQL.jpg","articleSection":["Python Advance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bees-team.com\/?p=179#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bees-team.com\/?p=179","url":"https:\/\/www.bees-team.com\/?p=179","name":"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python. - Experiment Log","isPartOf":{"@id":"https:\/\/www.bees-team.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bees-team.com\/?p=179#primaryimage"},"image":{"@id":"https:\/\/www.bees-team.com\/?p=179#primaryimage"},"thumbnailUrl":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/06\/Python-PostgreSQL.jpg","datePublished":"2022-06-05T14:26:30+00:00","dateModified":"2022-06-06T13:27:42+00:00","author":{"@id":"https:\/\/www.bees-team.com\/#\/schema\/person\/974321230684f994b6f3a28aa132b197"},"description":"PostgreSQL python","breadcrumb":{"@id":"https:\/\/www.bees-team.com\/?p=179#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bees-team.com\/?p=179"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bees-team.com\/?p=179#primaryimage","url":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/06\/Python-PostgreSQL.jpg","contentUrl":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/06\/Python-PostgreSQL.jpg","width":696,"height":410},{"@type":"BreadcrumbList","@id":"https:\/\/www.bees-team.com\/?p=179#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bees-team.com\/"},{"@type":"ListItem","position":2,"name":"Newbie \u2013 Python \u2013 PostgreSQL: K\u1ebft n\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u00eau PostgreSQL b\u1eb1ng ng\u00f4n ng\u1eef Python."}]},{"@type":"WebSite","@id":"https:\/\/www.bees-team.com\/#website","url":"https:\/\/www.bees-team.com\/","name":"Experiment Log","description":"Just note what I did","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bees-team.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.bees-team.com\/#\/schema\/person\/974321230684f994b6f3a28aa132b197","name":"Bees-Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g","caption":"Bees-Team"},"sameAs":["https:\/\/www.bees-team.com\/"],"url":"https:\/\/www.bees-team.com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=179"}],"version-history":[{"count":7,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":208,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions\/208"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/media\/181"}],"wp:attachment":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}