{"id":13746,"date":"2022-10-21T22:42:39","date_gmt":"2022-10-21T17:12:39","guid":{"rendered":"https:\/\/www.interviewbit.com\/blog\/?post_type=web-story&#038;p=13746"},"modified":"2022-10-21T22:47:21","modified_gmt":"2022-10-21T17:17:21","slug":"most-important-postgresql-commands","status":"publish","type":"web-story","link":"https:\/\/www.interviewbit.com\/blog\/web-stories\/most-important-postgresql-commands\/","title":{"rendered":"Important PostgreSQL Commands"},"content":{"rendered":"<p><html amp=\"\" lang=\"en\"><head><meta charSet=\"utf-8\"\/><meta name=\"viewport\" content=\"width=device-width,minimum-scale=1,initial-scale=1\"\/><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0.js\"><\/script><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0\/amp-story-1.0.js\" custom-element=\"amp-story\"><\/script><link href=\"https:\/\/fonts.googleapis.com\/css2?display=swap&amp;family=Roboto%3Awght%40400%3B700&amp;family=Darker+Grotesque%3Awght%40400%3B700&amp;family=Anton\" rel=\"stylesheet\"\/><link href=\"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAi\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif\" rel=\"preload\" as=\"image\"\/>\n<style amp-boilerplate=\"\">body{-webkit-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-moz-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-ms-animation:-amp-start 8s steps(1,end) 0s 1 normal both;animation:-amp-start 8s steps(1,end) 0s 1 normal both}@-webkit-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-moz-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-ms-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-o-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}<\/style>\n<p><noscript><\/p>\n<style amp-boilerplate=\"\">body{-webkit-animation:none;-moz-animation:none;-ms-animation:none;animation:none}<\/style>\n<p><\/noscript><\/p>\n<style amp-custom=\"\">\n              h1, h2, h3 { font-weight: normal; }<\/p>\n<p>              amp-story-page {\n                background-color: #131516;\n              }<\/p>\n<p>              amp-story-grid-layer {\n                overflow: visible;\n              }<\/p>\n<p>              @media (max-aspect-ratio: 9 \/ 16)  {\n                @media (min-aspect-ratio: 320 \/ 678) {\n                  amp-story-grid-layer.grid-layer {\n                    margin-top: calc((100% \/ 0.5625 - 100% \/ 0.6666666666666666) \/ 2);\n                  }\n                }\n              }<\/p>\n<p>              @media not all and (min-resolution:.001dpcm) {\n                @media {\n                  p.text-wrapper > span {\n                    font-size: calc(100% - 0.5px);\n                  }\n                }\n              }<\/p>\n<p>              .page-fullbleed-area,\n              .page-background-overlay-area {\n                position: absolute;\n                overflow: hidden;\n                width: 100%;\n                left: 0;\n                height: calc(1.1851851851851851 * 100%);\n                top: calc((1 - 1.1851851851851851) * 100% \/ 2);\n              }<\/p>\n<p>              .element-overlay-area {\n                position: absolute;\n                width: 100%;\n                height: 100%;\n                top: 0;\n                left: 0;\n              }<\/p>\n<p>              .page-safe-area {\n                overflow: visible;\n                position: absolute;\n                top: 0;\n                bottom: 0;\n                left: 0;\n                right: 0;\n                width: 100%;\n                height: calc(0.84375 * 100%);\n                margin: auto 0;\n              }<\/p>\n<p>              .mask {\n                position: absolute;\n                overflow: hidden;\n              }<\/p>\n<p>              .fill {\n                position: absolute;\n                top: 0;\n                left: 0;\n                right: 0;\n                bottom: 0;\n                margin: 0;\n              }<\/p>\n<p>              @media (prefers-reduced-motion: no-preference) {\n                .animation-wrapper {\n                  opacity: var(--initial-opacity);\n                  transform: var(--initial-transform);\n                }\n              }<\/p>\n<p>              amp-story-grid-layer.align-bottom {\n                align-content: end;\n                padding: 0;\n              }<\/p>\n<p>              .captions-area {\n                padding: 0 32px 0;\n              }<\/p>\n<p>              amp-story-captions {\n                margin-bottom: 16px;\n                text-align: center;\n              }<\/p>\n<p>              amp-story-captions span {\n                display: inline-block;\n                margin: 0;\n                padding: 6px 12px;\n                vertical-align: middle;\n                border-radius: 15px;\n                background: rgba(11, 11, 11, 0.6);\n                color: rgba(255, 255, 255, 1);\n                font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Oxygen-Sans, Ubuntu, Cantarell, \"Helvetica Neue\", sans-serif;;\n                font-size: calc(4 * var(--story-page-vw));\n                line-height: 1.4;\n                word-break: break-word;\n                word-wrap: break-word;\n                overflow-wrap: break-word;\n              }\n              <\/style>\n<p><meta name=\"web-stories-replace-head-start\"\/><title>Important PostgreSQL Commands<\/title><link rel=\"canonical\" href=\"https:\/\/www.interviewbit.com\/blog\/web-stories\/most-important-postgresql-commands\/\"\/><meta name=\"web-stories-replace-head-end\"\/><\/head><body><amp-story standalone=\"\" publisher=\"InterviewBit\" publisher-logo-src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/cropped-tumblr-logo.png\" title=\"Important PostgreSQL Commands\" poster-portrait-src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/10\/cropped-PostGre-SQL-Commands.png\"><amp-story-page id=\"2ba48566-4303-4648-be14-d8b890969253\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#c9d3d2\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-6a0b1206-de0c-46ff-842f-6cc0033f8086\">\n<div style=\"position:absolute;width:252.95238%;height:100%;left:-99.88889%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAi\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif\" alt=\"Spvgggreutherf\u00fcrth Fuerth Sticker\" srcSet=\"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAi\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif 498w,https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAj\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif 200w,https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAk\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif 90w\" sizes=\"(min-width: 1024px) 114vh, 253vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-84a9fe46-f171-471f-bb69-fb55fff093d6\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:57.9288%;width:76.94175%;height:31.5534%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 1.0256410256410255% 1.0256410256410255% 1.0256410256410255% 1.0256410256410255%\" id=\"el-5a03f828-20ca-4b52-b11f-7a23ec19dee9\">\n<h1 id=\"important-postgresql-commands\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.15723580441640422% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.889968em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Important PostgreSQL Commands<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.25243%;top:93.3657%;width:57.52427%;height:6.79612%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.8438818565400843% 0.8438818565400843% 0.8438818565400843% 0.8438818565400843% \/ 4.761904761904762% 4.761904761904762% 4.761904761904762% 4.761904761904762%\" id=\"el-9123c1d2-4727-4165-afb9-09a74535ff1a\">\n<h2 id=\"its-all-here\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.20767405063291136% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.566343em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #347eff\">Its all Here &gt;&gt;&gt;<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"47ddb9f2-270d-4b0d-993f-122d8b97f3fb\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-70a2c841-e6d1-4b54-99d6-67f6d3620875\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0659800e-6a63-45f0-992c-a58bd5fbccb8\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-715b475d-f40f-4822-8134-3cd31c0e151d\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2f594211-143c-4cf1-bc9a-7a74dfec902d\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-e047c62c-f158-4342-9ff7-ca4d071b504a [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#262626\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-e047c62c-f158-4342-9ff7-ca4d071b504a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-783eb30d-5544-49d0-ba8f-e169faf92c1a\">\n<div style=\"position:absolute;width:118.51852%;height:100%;left:-9.25926%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max\" alt=\"media\/unsplash:7wLQNYKL3Rw\" srcSet=\"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max 4000w,https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3200&amp;h=4800&amp;fit=max 3200w,https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2400&amp;h=3600&amp;fit=max 2400w,https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1600&amp;h=2400&amp;fit=max 1600w,https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=800&amp;h=1200&amp;fit=max 800w,https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=510&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:5.33981%;top:28.64078%;width:89.56311%;height:15.04854%;opacity:1\">\n<div id=\"anim-70a2c841-e6d1-4b54-99d6-67f6d3620875\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-0659800e-6a63-45f0-992c-a58bd5fbccb8\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5420054200542005% 0.5420054200542005% 0.5420054200542005% 0.5420054200542005% \/ 2.1505376344086025% 2.1505376344086025% 2.1505376344086025% 2.1505376344086025%\" id=\"el-7cd230c0-4238-4ec5-adce-927aef7b27e4\">\n<h1 id=\"introduction-to-postgresql\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:4.000000000000001% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.7;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #1263ff\">Introduction to PostgreSQL<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:49.83819%;width:84.95146%;height:33.17152%;opacity:1\">\n<div id=\"anim-715b475d-f40f-4822-8134-3cd31c0e151d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-2f594211-143c-4cf1-bc9a-7a74dfec902d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5714285714285714% 0.5714285714285714% 0.5714285714285714% 0.5714285714285714% \/ 0.975609756097561% 0.975609756097561% 0.975609756097561% 0.975609756097561%\" id=\"el-7bb8f5a3-dbd4-41bc-9727-7be2fd18d627\">\n<h2 id=\"postgresql-is-an-object-relational-database-system-with-a-solid-reputation-for-stability-robustness-and-performance-it-is-used-to-store-manipulate-and-display-data-in-an-application\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6240000000000003% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">PostgreSQL is an object-relational database system with a solid reputation for stability, robustness, and performance. It is used to store, manipulate and display data in an application.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f8872047-deb6-403b-ab89-8718af5e212d\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/04\/Kubectl-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"becbb31f-aa34-4058-b76e-6f59d68a9dae\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-6ddbb770-f78d-42af-8510-9ea9d81fb96f\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-97ed205c-9a15-4e0f-93f4-8f3e4ef31569\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-b36ec45c-da0c-44fc-a00f-c20143bd9fca\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-3fa4e2bd-1003-436a-9cab-9d85b8feaabb\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-befd3228-05a2-4d66-b3f9-758a11d36a1a [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a6e32d3b-c750-4406-b271-4be6ac118beb\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-7694dd9e-dcd6-4fd4-8f49-2e13fe77db03\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#c0a6a6\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-befd3228-05a2-4d66-b3f9-758a11d36a1a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-13788ef7-9d25-4518-ad46-0705b2e0fd4f\">\n<div style=\"position:absolute;width:237.03704%;height:100%;left:-68.51852%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5300&amp;h=3975&amp;fit=max\" alt=\"three men sitting on chair beside tables\" srcSet=\"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5300&amp;h=3975&amp;fit=max 5300w,https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4240&amp;h=3180&amp;fit=max 4240w,https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3180&amp;h=2385&amp;fit=max 3180w,https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2120&amp;h=1590&amp;fit=max 2120w,https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1060&amp;h=795&amp;fit=max 1060w,https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=255&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 107vh, 238vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:1.45631%;top:5.82524%;width:94.90291%;height:15.04854%;opacity:1\">\n<div id=\"anim-6ddbb770-f78d-42af-8510-9ea9d81fb96f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-97ed205c-9a15-4e0f-93f4-8f3e4ef31569\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5115089514066496% 0.5115089514066496% 0.5115089514066496% 0.5115089514066496% \/ 2.1505376344086025% 2.1505376344086025% 2.1505376344086025% 2.1505376344086025%\" id=\"el-e0b5e198-22a4-4ccc-a9ce-b141e1326301\">\n<h1 id=\"postgresql-commands-list\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:3.7749360613810747% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.7;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #1263ff\">PostgreSQL Commands List<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.00971%;top:39.96764%;width:83.00971%;height:49.67638%;opacity:1\">\n<div id=\"anim-b36ec45c-da0c-44fc-a00f-c20143bd9fca\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-3fa4e2bd-1003-436a-9cab-9d85b8feaabb\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5847953216374269% 0.5847953216374269% 0.5847953216374269% 0.5847953216374269% \/ 0.6514657980456027% 0.6514657980456027% 0.6514657980456027% 0.6514657980456027%\" id=\"el-71e82b17-746d-4d30-9fe6-72dfdfb24b08\">\n<h2 id=\"establishes-a-connection-with-the-database-under-the-control-of-the-specified-user-psql-d-database-u-user-w-here-d-specifies-database-name-and-u-specifies-database\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6385964912280705% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Establishes a connection with the database under the control of the specified user. &nbsp;&nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">psql -d database -U &nbsp;user -W &nbsp;<\/span><\/p>\n<p><span style=\"color: #fff\">Here, -d = specifies database name and -U = specifies database user.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-97d0e67d-fbd3-4fc1-9305-a39db530bf6f\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:26.86084%;width:92.47573%;height:11.48867%;opacity:1\">\n<div id=\"anim-a6e32d3b-c750-4406-b271-4be6ac118beb\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-7694dd9e-dcd6-4fd4-8f49-2e13fe77db03\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-85026927-416b-400f-be27-4d30cfee6104\">\n<h2 id=\"1-connect-to-postgresql-database\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">1. Connect to PostgreSQL Database<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"277173cc-5715-49f8-a52a-cc1d7614dffc\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-5fa6454f-9207-4af2-84b2-fb87698cbc9e\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-edd3611d-4948-4210-88f9-b9f4956258e1\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-dbabe1c6-17b1-495f-ac60-b79b16aef8b1 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-630802f3-1e0d-450c-b288-3d66c4332043\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2dfb8aef-c908-4776-8e32-8a540cc463ae\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-dbabe1c6-17b1-495f-ac60-b79b16aef8b1\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-97be699d-c148-4757-89c9-0b789dd4d4ea\">\n<div style=\"position:absolute;width:118.67612%;height:100%;left:-9.33806%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max\" alt=\"person using MacBook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max 4016w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3212&amp;h=4812&amp;fit=max 3212w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2409&amp;h=3609&amp;fit=max 2409w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1606&amp;h=2406&amp;fit=max 1606w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=803&amp;h=1203&amp;fit=max 803w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=509&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:49.51456%;width:83.73786%;height:27.83172%;opacity:1\">\n<div id=\"anim-5fa6454f-9207-4af2-84b2-fb87698cbc9e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-edd3611d-4948-4210-88f9-b9f4956258e1\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5797101449275363% 0.5797101449275363% 0.5797101449275363% 0.5797101449275363% \/ 1.1627906976744187% 1.1627906976744187% 1.1627906976744187% 1.1627906976744187%\" id=\"el-10a12e2a-8a3d-47a0-bb92-294a0c6e9cff\">\n<h2 id=\"switch-the-connection-to-a-new-database-while-logged-in-with-an-existing-user-c-dbname-username\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6330434782608698% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Switch the connection to a new database while logged in with an existing user.&nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">\\c dbname username<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-72a84abf-1733-492a-8831-b89e3efcd627\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.00971%;top:33.17152%;width:92.47573%;height:11.48867%;opacity:1\">\n<div id=\"anim-630802f3-1e0d-450c-b288-3d66c4332043\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-2dfb8aef-c908-4776-8e32-8a540cc463ae\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-1e0628fa-1c1e-4ab9-8b67-d5b828b2cc9e\">\n<h2 id=\"2-change-the-database-connection-to-a-new-one\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">2. Change the database connection to a new one<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"bc60c57e-a103-4417-900c-bd0d04f53aef\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-c05d883d-369a-4112-81f4-ea410d015aba\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a92518d5-09e5-4a51-9fe2-3592bd4ab8d2\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-1a39956a-a437-43a4-a199-915dc2c253d4 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-309217e4-6700-4ccb-a38b-ae093009d40d\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-5c037623-95a9-449c-9e01-9b184fd2b41e\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#262626\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-1a39956a-a437-43a4-a199-915dc2c253d4\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-998a0474-d77b-4894-aa13-0655967a53c6\">\n<div style=\"position:absolute;width:118.4%;height:100%;left:-9.2%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3996&amp;h=6000&amp;fit=max\" alt=\"sitting man using gadget in room\" srcSet=\"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3996&amp;h=6000&amp;fit=max 3996w,https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3196&amp;h=4799&amp;fit=max 3196w,https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2397&amp;h=3599&amp;fit=max 2397w,https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1598&amp;h=2399&amp;fit=max 1598w,https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=799&amp;h=1200&amp;fit=max 799w,https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=511&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:8.98058%;top:52.42718%;width:84.70874%;height:27.99353%;opacity:1\">\n<div id=\"anim-c05d883d-369a-4112-81f4-ea410d015aba\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-a92518d5-09e5-4a51-9fe2-3592bd4ab8d2\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5730659025787965% 0.5730659025787965% 0.5730659025787965% 0.5730659025787965% \/ 1.1560693641618496% 1.1560693641618496% 1.1560693641618496% 1.1560693641618496%\" id=\"el-84ea2df9-ceff-472a-bac3-cf281b1ff14a\">\n<h2 id=\"display-a-list-all-available-databases-in-the-current-postgresql-database-server-l\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6257879656160461% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Display a list all available databases in the current&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">PostgreSQL database server. &nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">\\l<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-862b947b-4784-44fc-942b-1fbbf26a1516\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:42.23301%;width:92.47573%;height:5.66343%;opacity:1\">\n<div id=\"anim-309217e4-6700-4ccb-a38b-ae093009d40d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-5c037623-95a9-449c-9e01-9b184fd2b41e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-88af2864-4605-4090-a6e6-56a5f93bc891\">\n<h2 id=\"3-list-available-database\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">3. List available database<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"f8edc689-b3b9-402a-bbe2-412ff0f6f60f\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-576214c0-3b55-487c-a942-b5a67d94527a [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(25%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-13fdf52e-6c14-4b42-bc82-02d4ef239ede\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-ceab1673-83c8-4276-b67b-30ea0a885c47\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-dbdef74c-2976-4b87-a79a-9665225181bd\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-125ec9e0-5f90-4408-bad0-070dd7a4dfa0\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#c0d9c0\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-576214c0-3b55-487c-a942-b5a67d94527a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-13922a8c-9d16-438b-bf06-93ebb7d22548\">\n<div style=\"position:absolute;width:118.57814%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=5304&amp;h=7952&amp;fit=max\" alt=\"man in pink button up shirt sitting beside woman in blue and black shirt\" srcSet=\"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=5304&amp;h=7952&amp;fit=max 5304w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4243&amp;h=6361&amp;fit=max 4243w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3182&amp;h=4771&amp;fit=max 3182w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2121&amp;h=3180&amp;fit=max 2121w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1060&amp;h=1589&amp;fit=max 1060w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=510&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:55.66343%;width:86.16505%;height:22.3301%;opacity:1\">\n<div id=\"anim-13fdf52e-6c14-4b42-bc82-02d4ef239ede\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-ceab1673-83c8-4276-b67b-30ea0a885c47\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5633802816901409% 0.5633802816901409% 0.5633802816901409% 0.5633802816901409% \/ 1.4492753623188406% 1.4492753623188406% 1.4492753623188406% 1.4492753623188406%\" id=\"el-c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6\">\n<h2 id=\"display-a-list-all-available-tables-in-the-current-database-dt\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.615211267605634% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Display a list all available tables in the current database. &nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">\\dt<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-98e33117-d578-4033-92ad-955225904a8e\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:44.01294%;width:92.47573%;height:5.66343%;opacity:1\">\n<div id=\"anim-dbdef74c-2976-4b87-a79a-9665225181bd\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-125ec9e0-5f90-4408-bad0-070dd7a4dfa0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-da9ec305-d54a-40fe-ba4e-011c09ffa739\">\n<h2 id=\"4-list-available-table\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">4. List available table<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"34846070-e323-4706-b26d-fb796e35a673\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-3c2fff42-00b9-4484-a87a-2f22ec0d33f1\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-cf2c668d-b896-4d59-8e19-2c916c3901dc\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-ff69f2b1-44f9-484e-9eb0-ed65f90aaa8a\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-482eb4ad-b9f9-49b1-b230-e4ab8835386f\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-ecb56278-3712-4bab-9f82-8ce04bf1074c [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#262626\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-ecb56278-3712-4bab-9f82-8ce04bf1074c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-2a49e5fe-7400-41ee-bdd0-0620e4c26af0\">\n<div style=\"position:absolute;width:266.31253%;height:100%;left:-83.15627%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6016&amp;h=4016&amp;fit=max\" alt=\"woman in black shirt using laptop computer\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6016&amp;h=4016&amp;fit=max 6016w,https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4812&amp;h=3212&amp;fit=max 4812w,https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3609&amp;h=2409&amp;fit=max 3609w,https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2406&amp;h=1606&amp;fit=max 2406w,https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1203&amp;h=803&amp;fit=max 1203w,https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=227&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 120vh, 267vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:55.66343%;width:86.16505%;height:27.99353%;opacity:1\">\n<div id=\"anim-3c2fff42-00b9-4484-a87a-2f22ec0d33f1\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-cf2c668d-b896-4d59-8e19-2c916c3901dc\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5633802816901409% 0.5633802816901409% 0.5633802816901409% 0.5633802816901409% \/ 1.1560693641618496% 1.1560693641618496% 1.1560693641618496% 1.1560693641618496%\" id=\"el-3b64d30f-89b8-4664-af6b-7fd1f71368a6\">\n<h2 id=\"describe-a-table-such-as-a-column-data-type-column-modifiers-and-so-on-d-table_name\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.615211267605634% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Describe a table, such as a column, data type, column modifiers, and so on. &nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">\\d table_name<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-897f2dbc-2e90-4c45-8640-36dd60797bea\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:44.01294%;width:92.47573%;height:5.66343%;opacity:1\">\n<div id=\"anim-ff69f2b1-44f9-484e-9eb0-ed65f90aaa8a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-482eb4ad-b9f9-49b1-b230-e4ab8835386f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-9efb615f-67cf-43c6-8413-86ab8e04c96a\">\n<h2 id=\"5-describe-table\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">5. Describe table<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"3f623322-1f10-4b73-a17c-b6211248fd7b\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-001f0308-11a0-4c32-aaab-15ef5473f301\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-e03395c0-c9c2-4526-aaaf-ce9a0cfe90e2\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-9672a188-d045-476e-ae0b-d26f12a09df9 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0e32fced-d44d-42b8-91f7-ea9a42755717\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-ca5adc4a-0317-4047-9ff6-38bf4eb288ce\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-9672a188-d045-476e-ae0b-d26f12a09df9\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-2a49e5fe-7400-41ee-bdd0-0620e4c26af0\">\n<div style=\"position:absolute;width:266.31253%;height:100%;left:-83.15627%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6016&amp;h=4016&amp;fit=max\" alt=\"three women sitting on sofa with MacBook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6016&amp;h=4016&amp;fit=max 6016w,https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4812&amp;h=3212&amp;fit=max 4812w,https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3609&amp;h=2409&amp;fit=max 3609w,https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2406&amp;h=1606&amp;fit=max 2406w,https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1203&amp;h=803&amp;fit=max 1203w,https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=227&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 120vh, 267vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:55.66343%;width:86.16505%;height:27.99353%;opacity:1\">\n<div id=\"anim-001f0308-11a0-4c32-aaab-15ef5473f301\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-e03395c0-c9c2-4526-aaaf-ce9a0cfe90e2\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5633802816901409% 0.5633802816901409% 0.5633802816901409% 0.5633802816901409% \/ 1.1560693641618496% 1.1560693641618496% 1.1560693641618496% 1.1560693641618496%\" id=\"el-3fdacff5-7655-4c54-b15b-6c73b0d1a770\">\n<h2 id=\"display-a-list-all-available-schemas-in-the-currently-connected-database-dn\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.615211267605634% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Display a list all available schemas in the currently connected database. &nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">\\dn<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-3ba03a3e-8852-4519-92dd-28e50ea8eb1e\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:44.01294%;width:92.47573%;height:5.66343%;opacity:1\">\n<div id=\"anim-0e32fced-d44d-42b8-91f7-ea9a42755717\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-ca5adc4a-0317-4047-9ff6-38bf4eb288ce\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-35b5628d-065d-4e32-801b-4c6c4b971fd6\">\n<h2 id=\"6-list-available-schema\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">6. List available schema<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/02\/Python-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"dbe68453-06e7-46ab-b4dd-093fe72a4d7d\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-5e10d1c6-abd0-4744-b047-3bfda0014c2a\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2facb83d-f33d-44a4-ba64-a972cfd6ca79\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-5de44d98-125e-4d13-81b3-857ebf17be9e [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-4e7d7eed-f953-4a4c-a243-f9cd647f6cb8\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2e4314cb-9625-46a2-a9fe-6948523ea338\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-5de44d98-125e-4d13-81b3-857ebf17be9e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-2a49e5fe-7400-41ee-bdd0-0620e4c26af0\">\n<div style=\"position:absolute;width:118.67612%;height:100%;left:-9.33806%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max\" alt=\"woman in black coat using MacBook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max 4016w,https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3212&amp;h=4812&amp;fit=max 3212w,https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2409&amp;h=3609&amp;fit=max 2409w,https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1606&amp;h=2406&amp;fit=max 1606w,https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=803&amp;h=1203&amp;fit=max 803w,https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=509&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:55.66343%;width:86.16505%;height:22.3301%;opacity:1\">\n<div id=\"anim-5e10d1c6-abd0-4744-b047-3bfda0014c2a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-2facb83d-f33d-44a4-ba64-a972cfd6ca79\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5633802816901409% 0.5633802816901409% 0.5633802816901409% 0.5633802816901409% \/ 1.4492753623188406% 1.4492753623188406% 1.4492753623188406% 1.4492753623188406%\" id=\"el-6bc38d4f-1c20-4aa6-8858-3d54d3d31c11\">\n<h2 id=\"display-a-list-of-available-functions-in-the-current-database-df\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.615211267605634% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Display a list of available functions in the current database. &nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #fff\">\\df<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-9a3b1e3f-475e-446f-b4d4-5ea3d7ae6951\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.52427%;top:44.01294%;width:92.47573%;height:5.66343%;opacity:1\">\n<div id=\"anim-4e7d7eed-f953-4a4c-a243-f9cd647f6cb8\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-2e4314cb-9625-46a2-a9fe-6948523ea338\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-b04fe47c-fdef-4503-bf72-d03f586e2b27\">\n<h2 id=\"7-list-available-function\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11072834645669291% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #347eff\">7. List available function<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">Learn More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"b2cd7624-c3ec-4a7d-9867-d7d4dc8f0933\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-cf77124b-134e-440f-87af-7c397dcd7334\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":1000,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-21292665-5b2e-49c5-8194-27e52491b3f2\",\"keyframes\":{\"transform\":[\"translate3d(0px, 161.14626%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":1000,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-477ee99f-e8ac-49c9-b4c3-b7a2a0338a30\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":200,\"duration\":1000,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a3e55bbb-8d9f-482b-bbf8-ae98ead8adec\",\"keyframes\":{\"transform\":[\"translate3d(0px, 293.70361%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":200,\"duration\":1000,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#b7b099\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-ae3f6c5c-5c72-4ba8-b6bc-e71174f9ed50\">\n<div style=\"position:absolute;width:177.77778%;height:100%;left:-38.88889%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAi\/cyrentec-sci-fi.gif\" alt=\"Cyrentec Sci Fi Sticker\" srcSet=\"https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAi\/cyrentec-sci-fi.gif 498w,https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAj\/cyrentec-sci-fi.gif 200w,https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAk\/cyrentec-sci-fi.gif 90w\" sizes=\"(min-width: 1024px) 80vh, 178vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:26.86084%;width:75.72816%;height:51.13269%;opacity:1\">\n<div id=\"anim-cf77124b-134e-440f-87af-7c397dcd7334\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-21292665-5b2e-49c5-8194-27e52491b3f2\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, 161.14626%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-021e0541-35be-4946-80af-40b0a2d780a0\">\n<h2 id=\"for-a-complete-list-of-postgresql-commands-with-examples\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.446883764022436% 0;font-family:&quot;Anton&quot;,sans-serif;font-size:0.809061em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #faf4ea\">For a Complete List of PostgreSQL Commands with examples.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:31.06796%;top:80.74434%;width:64.32039%;height:9.70874%;opacity:1\">\n<div id=\"anim-477ee99f-e8ac-49c9-b4c3-b7a2a0338a30\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-a3e55bbb-8d9f-482b-bbf8-ae98ead8adec\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, 293.70361%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-29f9c85b-0182-4652-b798-11c76752ed53\">\n<h2 id=\"click-here\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.3046875% 0;font-family:&quot;Anton&quot;,sans-serif;font-size:0.647249em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #ff630b\">Click Here<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-02d26325-9147-4e6e-be20-58b05760040a\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&amp;utm_medium=postgresql-commands&amp;utm_campaign=webstories\" rel=\"\">SWIPE UP<\/a><\/amp-story-page-outlink><\/amp-story-page><\/amp-story><\/body><\/html><\/p>\n","protected":false},"excerpt":{"rendered":"This web story will provide you with a short list of a few of the most important PostgreSQL commands that you should know.\n","protected":false},"author":21,"featured_media":13748,"template":"","meta":{"_daextam_enable_autolinks":"","web_stories_products":[],"web_stories_publisher_logo":1082,"web_stories_poster":[]},"web_story_category":[1793],"web_story_tag":[1835,1834],"amp_enabled":false,"story_data":{"version":43,"pages":[{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":249,"height":175,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"6a0b1206-de0c-46ff-842f-6cc0033f8086","basedOn":"11ef0ff2-7ece-45b6-b2ff-64736e54ce84","scale":100,"focalX":59.25577309236948,"focalY":50,"resource":{"baseColor":"#c9d3d2","type":"image","mimeType":"image\/gif","creationDate":"2021-07-29T14:09:46Z","src":"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAi\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif","width":498,"height":350,"id":"media\/tenor:6114623359895788246","alt":"Spvgggreutherf\u00fcrth Fuerth Sticker","sizes":{"full":{"file":"media\/tenor:6114623359895788246","sourceUrl":"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAi\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif","mimeType":"image\/gif","width":498,"height":350},"large":{"file":"media\/tenor:6114623359895788246","sourceUrl":"https:\/\/c.tenor.com\/VNuBjJXk2tYAAAAq\/tenor.gif","mimeType":"image\/gif","width":498,"height":350},"200_140":{"file":"media\/tenor:6114623359895788246","sourceUrl":"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAj\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif","mimeType":"image\/gif","width":200,"height":140},"web_stories_thumbnail":{"file":"media\/tenor:6114623359895788246","sourceUrl":"https:\/\/media.tenor.com\/VNuBjJXk2tYAAAAk\/spvgggreutherf%C3%BCrth-greutherf%C3%BCrth.gif","mimeType":"image\/gif","width":90,"height":63}},"attribution":{"author":{"displayName":"kleeblattfuerth","url":"https:\/\/tenor.com\/users\/kleeblattfuerth"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4totCvqxEkBm6TgIcBlYtUGl4M4%2B0nHbKBZloAobJfSRoHwwXQzpgWwIiaGbAalgu61MnyaFjFWiBEM3wzFHerjrEQ%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"bcc685a3-50e0-4220-aa2d-37d04255b533","id":"84a9fe46-f171-471f-bb69-fb55fff093d6"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":55,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Important PostgreSQL Commands<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":31,"y":358,"width":317,"height":195,"scale":100,"focalX":50,"focalY":50,"id":"5a03f828-20ca-4b52-b11f-7a23ec19dee9"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":35,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #347eff\">Its all Here &gt;&gt;&gt;<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":34,"y":577,"width":237,"height":42,"scale":100,"focalX":50,"focalY":50,"id":"9123c1d2-4727-4165-afb9-09a74535ff1a"}],"animations":[],"backgroundOverlay":"none","backgroundColor":{"color":{"r":0,"g":0,"b":0}},"type":"page","id":"2ba48566-4303-4648-be14-d8b890969253","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"42faa7f9-e2cf-4ec0-abf1-b11dff11646b","basedOn":"11ef0ff2-7ece-45b6-b2ff-64736e54ce84"},"pageAttachment":{"url":"","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/04\/Kubectl-Commands-2048x1000.png","needsProxy":false,"ctaText":"SWIPE UP"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"783eb30d-5544-49d0-ba8f-e169faf92c1a","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"LKBWJL0KWB%L~W9Gxut7xZIoxus:","type":"image","mimeType":"image\/jpeg","creationDate":"2021-09-14T12:57:24Z","src":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","width":4000,"height":6000,"id":"media\/unsplash:7wLQNYKL3Rw","alt":"media\/unsplash:7wLQNYKL3Rw","sizes":{"full":{"file":"media\/unsplash:7wLQNYKL3Rw","sourceUrl":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","mimeType":"image\/jpeg","width":4000,"height":6000},"large":{"file":"media\/unsplash:7wLQNYKL3Rw","sourceUrl":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=3200&h=4800&fit=max","mimeType":"image\/jpeg","width":3200,"height":4800},"2400_3600":{"file":"media\/unsplash:7wLQNYKL3Rw","sourceUrl":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=2400&h=3600&fit=max","mimeType":"image\/jpeg","width":2400,"height":3600},"1600_2400":{"file":"media\/unsplash:7wLQNYKL3Rw","sourceUrl":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=1600&h=2400&fit=max","mimeType":"image\/jpeg","width":1600,"height":2400},"800_1200":{"file":"media\/unsplash:7wLQNYKL3Rw","sourceUrl":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=800&h=1200&fit=max","mimeType":"image\/jpeg","width":800,"height":1200},"web_stories_thumbnail":{"file":"media\/unsplash:7wLQNYKL3Rw","sourceUrl":"https:\/\/images.unsplash.com\/photo-1631624210938-539575f92e3c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyNHx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"Mikhail Fesenko","url":"https:\/\/unsplash.com\/@proggga?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4trhsTBxm\/6gFbgX28yUJ7OS1W92A8NS56%2BLfPfFRmKWvhaCR1BqvtSBkOcWIjMMjaxrNaqCqJHjmNaY4DaaySGy7ArbHIsHLc6GUrXW2rGtkMNlXAhfzs8SATbBi4Ipg5R0XCJtI2D8GL1TwOck4hyBeHMlsR\/RSXRV3gUb%2B338sGPFnHKqnHloW1njXhLYwYR4a4j3Ba5sQ\/rB1BEjQKKnZYfGLTfgm1RVdYakMLP7jr46I\/8EIUTfjlWIlPFyRs3rsA%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.7,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false},"type":"text","content":"<span style=\"font-weight: 700; color: #1263ff\">Introduction to PostgreSQL<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":22,"y":177,"width":369,"height":93,"scale":100,"focalX":50,"focalY":50,"id":"7cd230c0-4238-4ec5-adce-927aef7b27e4","marginOffset":-33.45600000000001,"basedOn":"14bb0c1d-b114-4235-8cfa-a9650723dd19","groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">PostgreSQL is an object-relational database system with a solid reputation for stability, robustness, and performance. It is used to store, manipulate and display data in an application.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":350,"height":205,"scale":100,"focalX":50,"focalY":50,"basedOn":"9b73ef3b-3831-463a-995d-86e6b3244924","id":"7bb8f5a3-dbd4-41bc-9727-7be2fd18d627","x":31,"y":308,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"84a9fe46-f171-471f-bb69-fb55fff093d6","id":"f8872047-deb6-403b-ab89-8718af5e212d"}],"animations":[{"id":"0b028b83-7635-4a07-9ab3-2c88bd973be3","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["7cd230c0-4238-4ec5-adce-927aef7b27e4"]},{"id":"b54acda9-6d33-4bf3-adf3-81d52bd5d0a9","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["7bb8f5a3-dbd4-41bc-9727-7be2fd18d627"]},{"id":"f3cf2c0c-e002-4d51-b8e6-67caf75950a8","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["783eb30d-5544-49d0-ba8f-e169faf92c1a"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"47ddb9f2-270d-4b0d-993f-122d8b97f3fb","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"70949b53-d0cf-4b7c-a06d-027a74825292","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/04\/Kubectl-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":247,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"13788ef7-9d25-4518-ad46-0705b2e0fd4f","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#c0a6a6","blurHash":"LLGk%kx@IqIq~qX8V[xtt3t6bIxt","type":"image","mimeType":"image\/jpeg","creationDate":"2019-05-02T01:40:00Z","src":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=5300&h=3975&fit=max","width":5300,"height":3975,"id":"media\/unsplash:mpN7xjKQ_Ns","alt":"three men sitting on chair beside tables","sizes":{"full":{"file":"media\/unsplash:mpN7xjKQ_Ns","sourceUrl":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=5300&h=3975&fit=max","mimeType":"image\/jpeg","width":5300,"height":3975},"large":{"file":"media\/unsplash:mpN7xjKQ_Ns","sourceUrl":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=4240&h=3180&fit=max","mimeType":"image\/jpeg","width":4240,"height":3180},"3180_2385":{"file":"media\/unsplash:mpN7xjKQ_Ns","sourceUrl":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=3180&h=2385&fit=max","mimeType":"image\/jpeg","width":3180,"height":2385},"2120_1590":{"file":"media\/unsplash:mpN7xjKQ_Ns","sourceUrl":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=2120&h=1590&fit=max","mimeType":"image\/jpeg","width":2120,"height":1590},"1060_795":{"file":"media\/unsplash:mpN7xjKQ_Ns","sourceUrl":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=1060&h=795&fit=max","mimeType":"image\/jpeg","width":1060,"height":795},"web_stories_thumbnail":{"file":"media\/unsplash:mpN7xjKQ_Ns","sourceUrl":"https:\/\/images.unsplash.com\/photo-1556761175-b413da4baf72?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY4NA&ixlib=rb-4.0.3&fm=jpg&w=340&h=255&fit=max","mimeType":"image\/jpeg","width":340,"height":255}},"attribution":{"author":{"displayName":"Austin Distel","url":"https:\/\/unsplash.com\/@austindistel?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4trRMX7Z7ORVDO7cXRyd1M3MEVacJ\/IwP63sZPQo2gukIbg7L4wVJ3MP9dDcxthRA7FSUkkJtf0iX4n8ZtZ65DUcJKyVCC8q4SCZ%2B%2B1v3eVJV0oxkKqdoUIEj56DxeZFcz\/T0MmOcsJ6dH2DEj2QQplH1Ay3IE8uz%2BOvJcDNbIU2JPtuLZKPVUCWwnf9r6\/q6yDCYRRN3sJ0at3ZaLam24OznvXMzvYJHkWX2OgUAwsyU7xAOBRhWI5FiC9aaJJUqsse"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.7,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false},"type":"text","content":"<span style=\"font-weight: 700; color: #1263ff\">PostgreSQL Commands List<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":6,"y":36,"width":391,"height":93,"scale":100,"focalX":50,"focalY":50,"id":"e0b5e198-22a4-4ccc-a9ce-b141e1326301","marginOffset":-33.45600000000001,"basedOn":"81b4f684-4af9-4c2f-80ef-3031feb0b986","groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Establishes a connection with the database under the control of the specified user. &nbsp;&nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">psql -d database -U &nbsp;user -W &nbsp;<\/span>\n\n<span style=\"color: #fff\">Here, -d = specifies database name and -U = specifies database user.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":342,"height":307,"scale":100,"focalX":50,"focalY":50,"basedOn":"a0259225-7078-482e-8257-f773446493c0","id":"71e82b17-746d-4d30-9fe6-72dfdfb24b08","x":33,"y":247,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"84a9fe46-f171-471f-bb69-fb55fff093d6","id":"97d0e67d-fbd3-4fc1-9305-a39db530bf6f"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">1. Connect to PostgreSQL Database<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":31,"y":166,"width":381,"height":71,"scale":100,"focalX":50,"focalY":50,"id":"85026927-416b-400f-be27-4d30cfee6104"}],"animations":[{"id":"24e371db-eda8-4628-8f63-35b0cfa6b509","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["e0b5e198-22a4-4ccc-a9ce-b141e1326301"]},{"id":"1b0ed17a-b718-421b-a005-8c142f9224e4","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["71e82b17-746d-4d30-9fe6-72dfdfb24b08"]},{"id":"2cca52bc-4e96-494b-9545-888d309ac116","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["13788ef7-9d25-4518-ad46-0705b2e0fd4f"]},{"id":"844add14-1cc6-4337-ad89-0c5a6703755f","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["85026927-416b-400f-be27-4d30cfee6104"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"becbb31f-aa34-4058-b76e-6f59d68a9dae","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"28ce94fb-2547-44cf-9505-5d6521e2f856","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"97be699d-c148-4757-89c9-0b789dd4d4ea","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LKIhgNI;-;~W4.eSRPS5~CtlD*ad","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-11T18:11:49Z","src":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=4016&h=6016&fit=max","width":4016,"height":6016,"id":"media\/unsplash:5UHFPbvBBzY","alt":"person using MacBook","sizes":{"full":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=4016&h=6016&fit=max","mimeType":"image\/jpeg","width":4016,"height":6016},"large":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=3212&h=4812&fit=max","mimeType":"image\/jpeg","width":3212,"height":4812},"2409_3609":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=2409&h=3609&fit=max","mimeType":"image\/jpeg","width":2409,"height":3609},"1606_2406":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=1606&h=2406&fit=max","mimeType":"image\/jpeg","width":1606,"height":2406},"803_1203":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=803&h=1203&fit=max","mimeType":"image\/jpeg","width":803,"height":1203},"web_stories_thumbnail":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0NXx8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQxMDU&ixlib=rb-1.2.1&fm=jpg&w=340&h=509&fit=max","mimeType":"image\/jpeg","width":340,"height":509}},"attribution":{"author":{"displayName":"Christina @ wocintechchat.com","url":"https:\/\/unsplash.com\/@wocintechchat?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tredJJO7idasZageI24Y4zWGZw3rVxrJfLRSwHz29iISFY6hlIaVxT%2Boj5IPq3ROSskXeoStDrPWL6lR8VXRyfdSQjmIYSGSS8FvStHBc6c0FDIwbc0LKF%2BidVSl3ydnY3S%2B4D3VdU50dc7HbHkxu4zH9gT\/I\/bfg2LRwWq2P%2BxjrBfCWMwXjbCv\/VCF5CFloW25Ag0TcPup2o\/sfRjcdbDjNvfnZUuLtYPVo5jS1k2fWTbmy7avN4wCiH17sFaPIo0pg%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Switch the connection to a new database while logged in with an existing user.&nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">\\c dbname username<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":345,"height":172,"scale":100,"focalX":50,"focalY":50,"basedOn":"e5fd183e-3dbc-4fb1-958a-be04a3706844","id":"10a12e2a-8a3d-47a0-bb92-294a0c6e9cff","x":36,"y":306,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"84a9fe46-f171-471f-bb69-fb55fff093d6","id":"72a84abf-1733-492a-8831-b89e3efcd627"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">2. Change the database connection to a new one<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":33,"y":205,"width":381,"height":71,"scale":100,"focalX":50,"focalY":50,"basedOn":"85026927-416b-400f-be27-4d30cfee6104","id":"1e0628fa-1c1e-4ab9-8b67-d5b828b2cc9e"}],"animations":[{"id":"d02c37e2-403d-4f25-a8cc-290236e457a1","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["10a12e2a-8a3d-47a0-bb92-294a0c6e9cff"]},{"id":"87b85084-01d1-48d3-b1fb-72e999714957","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["97be699d-c148-4757-89c9-0b789dd4d4ea"]},{"id":"f536cce2-07e3-4cbb-ac9d-becbd213d547","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["1e0628fa-1c1e-4ab9-8b67-d5b828b2cc9e"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"277173cc-5715-49f8-a52a-cc1d7614dffc","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"c434eade-3204-4853-b2e8-7ec9b49b89b7","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":495,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"998a0474-d77b-4894-aa13-0655967a53c6","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"L897hU*JxtNG4mMJnhxvI;-;krRj","type":"image","mimeType":"image\/jpeg","creationDate":"2019-02-09T06:08:56Z","src":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=3996&h=6000&fit=max","width":3996,"height":6000,"id":"media\/unsplash:G1N9kDHqBrQ","alt":"sitting man using gadget in room","sizes":{"full":{"file":"media\/unsplash:G1N9kDHqBrQ","sourceUrl":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=3996&h=6000&fit=max","mimeType":"image\/jpeg","width":3996,"height":6000},"large":{"file":"media\/unsplash:G1N9kDHqBrQ","sourceUrl":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=3196&h=4799&fit=max","mimeType":"image\/jpeg","width":3196,"height":4799},"2397_3599":{"file":"media\/unsplash:G1N9kDHqBrQ","sourceUrl":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=2397&h=3599&fit=max","mimeType":"image\/jpeg","width":2397,"height":3599},"1598_2399":{"file":"media\/unsplash:G1N9kDHqBrQ","sourceUrl":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=1598&h=2399&fit=max","mimeType":"image\/jpeg","width":1598,"height":2399},"799_1200":{"file":"media\/unsplash:G1N9kDHqBrQ","sourceUrl":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=799&h=1200&fit=max","mimeType":"image\/jpeg","width":799,"height":1200},"web_stories_thumbnail":{"file":"media\/unsplash:G1N9kDHqBrQ","sourceUrl":"https:\/\/images.unsplash.com\/photo-1549692520-acc6669e2f0c?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyN3x8c29mdHdhcmUlMjBkZXZlbG9wbWVudHxlbnwwfHx8fDE2NjYwMDQwNzM&ixlib=rb-1.2.1&fm=jpg&w=340&h=511&fit=max","mimeType":"image\/jpeg","width":340,"height":511}},"attribution":{"author":{"displayName":"Arif Riyanto","url":"https:\/\/unsplash.com\/@arifriyanto?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tooEWTGMuIytUrzLZw2pRbIZZK5Wn5vSu0b8NZWX8B2MVq4KrmjWnIbGYhzy2m\/cTI93vyteatHlBJCtmwD0paORdGAQ0JenyvRYF%2BY48h3hd%2B8W4GOCahVeSDJ8uyR4nsGMZTqruUUE5X9eqZAgBs6Eyj4lfGV4tJWzMP8fgAiDcBdtrmZYIgeqKBuLscGM9SkFOe%2B2JRMf3FmAoxAugMzxEi0j17R5cRXdAeeJijcae9Pg%2BWA\/mxXw1YDYwUIgIIqBQ%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Display a list all available databases in the current&nbsp;<\/span>\n<span style=\"color: #fff\">PostgreSQL database server. &nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">\\l<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":349,"height":173,"scale":100,"focalX":50,"focalY":50,"basedOn":"8255e0b1-21c3-433d-8b5a-3d960f385949","id":"84ea2df9-ceff-472a-bac3-cf281b1ff14a","x":37,"y":324,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"84a9fe46-f171-471f-bb69-fb55fff093d6","id":"862b947b-4784-44fc-942b-1fbbf26a1516"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">3. List available database<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":36,"y":261,"width":381,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"1e0628fa-1c1e-4ab9-8b67-d5b828b2cc9e","id":"88af2864-4605-4090-a6e6-56a5f93bc891"}],"animations":[{"id":"ce9d43d9-54b3-44ca-9596-a05196311a3a","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["84ea2df9-ceff-472a-bac3-cf281b1ff14a"]},{"id":"d84bee45-db27-4ae2-9dde-cf7249eba634","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["998a0474-d77b-4894-aa13-0655967a53c6"]},{"id":"54f6203d-450e-44bd-aec8-6e41deb46624","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["88af2864-4605-4090-a6e6-56a5f93bc891"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"bc60c57e-a103-4417-900c-bd0d04f53aef","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"dc272169-4273-4662-87a5-608e815f91a2","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"13922a8c-9d16-438b-bf06-93ebb7d22548","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":42.0556266524354,"focalY":50.06793410279936,"resource":{"baseColor":"#c0d9c0","blurHash":"LOGbxBXA0LM{9G%1ocR*GGRk?Hof","type":"image","mimeType":"image\/jpeg","creationDate":"2020-02-05T09:34:15Z","src":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=5304&h=7952&fit=max","width":5304,"height":7952,"id":"media\/unsplash:lLrZy195sIU","alt":"man in pink button up shirt sitting beside woman in blue and black shirt","sizes":{"full":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=5304&h=7952&fit=max","mimeType":"image\/jpeg","width":5304,"height":7952},"large":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=4243&h=6361&fit=max","mimeType":"image\/jpeg","width":4243,"height":6361},"3182_4771":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=3182&h=4771&fit=max","mimeType":"image\/jpeg","width":3182,"height":4771},"2121_3180":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=2121&h=3180&fit=max","mimeType":"image\/jpeg","width":2121,"height":3180},"1060_1589":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=1060&h=1589&fit=max","mimeType":"image\/jpeg","width":1060,"height":1589},"web_stories_thumbnail":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"ThisisEngineering RAEng","url":"https:\/\/unsplash.com\/@thisisengineering?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=ARX97wMOJMXa0uo3y5kR4JNv3ZZXWjDaHwfxD8TLku8DPrYyDhMVQVCHhh3UN8UcxojHwg2kUCif7FoJgyPW7sMKEkG6GbukKjTvuFMoTGgmBpuitk1VWC1nvSzsSo9jpHXTpHvd3nR%2BNzAJDQH0jKb%2B\/cYk5ClBwdQxDGTCm\/v6knvpf96HnyWw\/xN\/p44l11kNvdRHIA1dYFng9DIv20x6ypAhqFkSicP94UdOWIgYPJKWXEJxTdQeTDjdtYUWrBGT"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Display a list all available tables in the current database. &nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">\\dt<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":355,"height":138,"scale":100,"focalX":50,"focalY":50,"basedOn":"8255e0b1-21c3-433d-8b5a-3d960f385949","id":"c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6","x":31,"y":344,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"84a9fe46-f171-471f-bb69-fb55fff093d6","id":"98e33117-d578-4033-92ad-955225904a8e"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">4. List available table<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":31,"y":272,"width":381,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"88af2864-4605-4090-a6e6-56a5f93bc891","id":"da9ec305-d54a-40fe-ba4e-011c09ffa739"}],"animations":[{"targets":["13922a8c-9d16-438b-bf06-93ebb7d22548"],"id":"3a976783-20e2-4e32-ab73-06bf4198f9a8","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0},{"id":"09d769b1-5688-4627-913c-754d3c10428b","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6"]},{"id":"ef73cafe-27ab-43c5-b315-d395a102827f","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["da9ec305-d54a-40fe-ba4e-011c09ffa739"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"f8edc689-b3b9-402a-bbe2-412ff0f6f60f","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":220,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"LFAmC_58$%I:~VE2t8W?WrflIo%1","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-07T22:13:50Z","src":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=6016&h=4016&fit=max","width":6016,"height":4016,"id":"media\/unsplash:L85a1k-XqH8","alt":"woman in black shirt using laptop computer","sizes":{"full":{"file":"media\/unsplash:L85a1k-XqH8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=6016&h=4016&fit=max","mimeType":"image\/jpeg","width":6016,"height":4016},"large":{"file":"media\/unsplash:L85a1k-XqH8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=4812&h=3212&fit=max","mimeType":"image\/jpeg","width":4812,"height":3212},"3609_2409":{"file":"media\/unsplash:L85a1k-XqH8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=3609&h=2409&fit=max","mimeType":"image\/jpeg","width":3609,"height":2409},"2406_1606":{"file":"media\/unsplash:L85a1k-XqH8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=2406&h=1606&fit=max","mimeType":"image\/jpeg","width":2406,"height":1606},"1203_803":{"file":"media\/unsplash:L85a1k-XqH8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=1203&h=803&fit=max","mimeType":"image\/jpeg","width":1203,"height":803},"web_stories_thumbnail":{"file":"media\/unsplash:L85a1k-XqH8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164713712-03790a178651?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDY5Ng&ixlib=rb-4.0.3&fm=jpg&w=340&h=227&fit=max","mimeType":"image\/jpeg","width":340,"height":227}},"attribution":{"author":{"displayName":"Christina @ wocintechchat.com","url":"https:\/\/unsplash.com\/@wocintechchat?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tpUK7LmuVs8hywyG7ZNT\/IANFQMT5EQVFmKXUhmFGJLcYOybJyAHjY5cN7LFcg7\/au35WOJNwQa8eFQErZFjDPC09pKVbcd7nFwi4Dne6aJ\/agIcZvksCWUxhFQRuXH8Lqv89gRqDmAwh1d0MLN\/9e6EOXZ\/1n4ZlYPaSWSIHgSXZJvPnoi8FQcrOShyJqInuAHqCREV07vTahGggYgiw\/MG1Clw7Kbb%2BGCxpQYdAzcxRorXs5\/MGm4\/d5uHS8vkKrc"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Describe a table, such as a column, data type, column modifiers, and so on. &nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">\\d table_name<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":355,"height":173,"scale":100,"focalX":50,"focalY":50,"basedOn":"c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6","id":"3b64d30f-89b8-4664-af6b-7fd1f71368a6","x":31,"y":344,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"98e33117-d578-4033-92ad-955225904a8e","id":"897f2dbc-2e90-4c45-8640-36dd60797bea"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">5. Describe table<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":31,"y":272,"width":381,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"da9ec305-d54a-40fe-ba4e-011c09ffa739","id":"9efb615f-67cf-43c6-8413-86ab8e04c96a"}],"animations":[{"id":"c9276fae-e74f-4aaf-a4e1-1262b1c283b5","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["3b64d30f-89b8-4664-af6b-7fd1f71368a6"]},{"id":"c276f47f-0887-4cd5-b6e6-a447b24be51a","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["9efb615f-67cf-43c6-8413-86ab8e04c96a"]},{"id":"dcb112dd-a47e-4ef2-b6a5-f6e88dd5fa4f","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["2a49e5fe-7400-41ee-bdd0-0620e4c26af0"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"34846070-e323-4706-b26d-fb796e35a673","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"8722c1f8-c489-4592-a501-0f39794d6413","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":220,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LsJ@wRb_%MRj~Ux^Rlod-obckDj?","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-07T22:18:33Z","src":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=6016&h=4016&fit=max","width":6016,"height":4016,"id":"media\/unsplash:OW5KP_Pj85Q","alt":"three women sitting on sofa with MacBook","sizes":{"full":{"file":"media\/unsplash:OW5KP_Pj85Q","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=6016&h=4016&fit=max","mimeType":"image\/jpeg","width":6016,"height":4016},"large":{"file":"media\/unsplash:OW5KP_Pj85Q","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=4812&h=3212&fit=max","mimeType":"image\/jpeg","width":4812,"height":3212},"3609_2409":{"file":"media\/unsplash:OW5KP_Pj85Q","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=3609&h=2409&fit=max","mimeType":"image\/jpeg","width":3609,"height":2409},"2406_1606":{"file":"media\/unsplash:OW5KP_Pj85Q","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=2406&h=1606&fit=max","mimeType":"image\/jpeg","width":2406,"height":1606},"1203_803":{"file":"media\/unsplash:OW5KP_Pj85Q","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=1203&h=803&fit=max","mimeType":"image\/jpeg","width":1203,"height":803},"web_stories_thumbnail":{"file":"media\/unsplash:OW5KP_Pj85Q","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165067541-4cd6d9837902?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgwMQ&ixlib=rb-4.0.3&fm=jpg&w=340&h=227&fit=max","mimeType":"image\/jpeg","width":340,"height":227}},"attribution":{"author":{"displayName":"Christina @ wocintechchat.com","url":"https:\/\/unsplash.com\/@wocintechchat?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4toMAsn0X73ZVZKL8tq8eMrDFvRIgoHr\/Mi8%2Bn5KkVDkC0QkWbjLGpzzx0S706\/l1BfRd3SVBO84OLsaGdCjqUr3oMuJarU98km8oEExftQ%2BbkIzDZO8omOwRUxttxeo5XmiHQwq%2BhF5HXfqdF6UzIHRab%2B7vqBL3uxLtInRT84nVH6Hf\/pZ0a5p%2BJ%2ByowcsgbF4VX2xMc65UqanwLMOLCPYO8j104Q93Uvw8ZOu2jv7zIbpHTO4mWPmbRiglvAe2jBQ"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Display a list all available schemas in the currently connected database. &nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">\\dn<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":355,"height":173,"scale":100,"focalX":50,"focalY":50,"basedOn":"3b64d30f-89b8-4664-af6b-7fd1f71368a6","id":"3fdacff5-7655-4c54-b15b-6c73b0d1a770","x":31,"y":344,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"897f2dbc-2e90-4c45-8640-36dd60797bea","id":"3ba03a3e-8852-4519-92dd-28e50ea8eb1e"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">6. List available schema<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":31,"y":272,"width":381,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"9efb615f-67cf-43c6-8413-86ab8e04c96a","id":"35b5628d-065d-4e32-801b-4c6c4b971fd6"}],"animations":[{"id":"2d68a54c-f0be-4c97-a600-616e90850b90","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["3fdacff5-7655-4c54-b15b-6c73b0d1a770"]},{"id":"a3f1a309-2445-471e-a505-216e265a1b60","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["2a49e5fe-7400-41ee-bdd0-0620e4c26af0"]},{"id":"82137ad3-7088-4762-83ba-67c24a675427","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["35b5628d-065d-4e32-801b-4c6c4b971fd6"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"3f623322-1f10-4b73-a17c-b6211248fd7b","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"5ffffa7c-c6ac-4696-80bb-cc44016dbe8f","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/02\/Python-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LhKx3f_3-;R*~q-;D*n$-;M{Mxt7","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-07T22:56:03Z","src":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=4016&h=6016&fit=max","width":4016,"height":6016,"id":"media\/unsplash:8jwCWlsBys8","alt":"woman in black coat using MacBook","sizes":{"full":{"file":"media\/unsplash:8jwCWlsBys8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=4016&h=6016&fit=max","mimeType":"image\/jpeg","width":4016,"height":6016},"large":{"file":"media\/unsplash:8jwCWlsBys8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=3212&h=4812&fit=max","mimeType":"image\/jpeg","width":3212,"height":4812},"2409_3609":{"file":"media\/unsplash:8jwCWlsBys8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=2409&h=3609&fit=max","mimeType":"image\/jpeg","width":2409,"height":3609},"1606_2406":{"file":"media\/unsplash:8jwCWlsBys8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=1606&h=2406&fit=max","mimeType":"image\/jpeg","width":1606,"height":2406},"803_1203":{"file":"media\/unsplash:8jwCWlsBys8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=803&h=1203&fit=max","mimeType":"image\/jpeg","width":803,"height":1203},"web_stories_thumbnail":{"file":"media\/unsplash:8jwCWlsBys8","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573166953836-06864dc70a21?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5Mnx8c29mdHdhcmUlMjBkZXZlbG9wZXJzfGVufDB8fHx8MTY2NjM2MDgxMA&ixlib=rb-4.0.3&fm=jpg&w=340&h=509&fit=max","mimeType":"image\/jpeg","width":340,"height":509}},"attribution":{"author":{"displayName":"Christina @ wocintechchat.com","url":"https:\/\/unsplash.com\/@wocintechchat?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tqUVUPzQh2%2Bxdmm6GI84G4wG\/rkkHS7mjvTOD4kbc%2BOIMQ7gq1B8cH1GeA3PI4Js3DeCl\/vBKljwHGNLKaPEDR303uWepMTgw27ykb%2B%2B%2Bj6MaGuMFS2Cdp2HaC7idzatnVhbxNtNZWCM077QG5x4TzfySmwbwWASRB1yuySq0\/TECQOhAH3fBFIwCjtlN7ysbvEgBQA2E%2Bt3Bmw87c57BwYgUx%2BHh3%2BtD0D41mZ2nq93fy6fQkKEvtEEl0h2JHEn46q"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Display a list of available functions in the current database. &nbsp;<\/span>\n\n<span style=\"font-weight: 700; color: #fff\">\\df<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":355,"height":138,"scale":100,"focalX":50,"focalY":50,"basedOn":"3fdacff5-7655-4c54-b15b-6c73b0d1a770","id":"6bc38d4f-1c20-4aa6-8858-3d54d3d31c11","x":31,"y":344,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"3ba03a3e-8852-4519-92dd-28e50ea8eb1e","id":"9a3b1e3f-475e-446f-b4d4-5ea3d7ae6951"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #347eff\">7. List available function<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":31,"y":272,"width":381,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"35b5628d-065d-4e32-801b-4c6c4b971fd6","id":"b04fe47c-fdef-4503-bf72-d03f586e2b27"}],"animations":[{"id":"cee88803-f9a6-4daa-ae77-9a6c49c01baf","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["6bc38d4f-1c20-4aa6-8858-3d54d3d31c11"]},{"id":"d433e4ec-55a4-47e8-b128-9492720bdc1d","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["2a49e5fe-7400-41ee-bdd0-0620e4c26af0"]},{"id":"920ef851-8f89-4877-9316-254852f0a618","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["b04fe47c-fdef-4503-bf72-d03f586e2b27"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"dbe68453-06e7-46ab-b4dd-093fe72a4d7d","pageTemplateType":"section","groups":[],"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"4cc48d5a-9394-4ff0-890f-8182229df6eb","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"Learn More"}},{"elements":[{"x":48,"y":0,"width":249,"height":249,"type":"image","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"mask":{"type":"rectangle"},"isBackground":true,"id":"ae3f6c5c-5c72-4ba8-b6bc-e71174f9ed50","basedOn":"5249418e-8fb7-46d7-8af1-835671d52f2b","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#b7b099","type":"image","mimeType":"image\/gif","creationDate":"2022-04-02T03:43:01Z","src":"https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAi\/cyrentec-sci-fi.gif","width":498,"height":498,"id":"media\/tenor:7065882667163916870","alt":"Cyrentec Sci Fi Sticker","sizes":{"full":{"file":"media\/tenor:7065882667163916870","sourceUrl":"https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAi\/cyrentec-sci-fi.gif","mimeType":"image\/gif","width":498,"height":498},"large":{"file":"media\/tenor:7065882667163916870","sourceUrl":"https:\/\/c.tenor.com\/Yg8O2WDlGkYAAAAq\/tenor.gif","mimeType":"image\/gif","width":498,"height":498},"200_200":{"file":"media\/tenor:7065882667163916870","sourceUrl":"https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAj\/cyrentec-sci-fi.gif","mimeType":"image\/gif","width":200,"height":200},"web_stories_thumbnail":{"file":"media\/tenor:7065882667163916870","sourceUrl":"https:\/\/media.tenor.com\/Yg8O2WDlGkYAAAAk\/cyrentec-sci-fi.gif","mimeType":"image\/gif","width":90,"height":90}},"attribution":{"author":{"displayName":"blaineam","url":"https:\/\/tenor.com\/users\/blaineam"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tolPv7NHJ5srGRbD3p841gzq9EE7XMSBANJ%2BE7TrlOOyJ48eXxuQIkbyLD0JDMTJsGYccFakkIyhW4SMzRcEFKBJg%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":48,"y":166,"width":312,"height":316,"font":{"family":"Anton","fallbacks":["sans-serif"],"weights":[400],"styles":["regular"],"variants":[[0,400]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":2409,"des":-674,"tAsc":2409,"tDes":-674,"tLGap":0,"wAsc":2876,"wDes":674,"xH":1500,"capH":1760,"yMin":-667,"yMax":2874,"hAsc":2409,"hDes":-674,"lGap":0}},"type":"text","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","scale":100,"focalX":50,"focalY":50,"basedOn":"457c0ed6-69da-43c4-ac59-1d1359d980b9","id":"021e0541-35be-4946-80af-40b0a2d780a0","content":"<span style=\"color: #faf4ea\">For a Complete List of PostgreSQL Commands with examples.<\/span>","fontSize":50,"padding":{"horizontal":0,"vertical":0},"tagName":"h2","marginOffset":-34.87060546875},{"x":128,"y":499,"width":265,"height":60,"font":{"family":"Anton","fallbacks":["sans-serif"],"weights":[400],"styles":["regular"],"variants":[[0,400]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":2409,"des":-674,"tAsc":2409,"tDes":-674,"tLGap":0,"wAsc":2876,"wDes":674,"xH":1500,"capH":1760,"yMin":-667,"yMax":2874,"hAsc":2409,"hDes":-674,"lGap":0}},"type":"text","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","scale":100,"focalX":50,"focalY":50,"basedOn":"b0b134b8-2aae-4da8-83be-a0f5a811f082","id":"29f9c85b-0182-4652-b798-11c76752ed53","content":"<span style=\"color: #ff630b\">Click Here<\/span>","fontSize":40,"padding":{"horizontal":0,"vertical":0},"tagName":"h2","marginOffset":-36.38671875},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"84a9fe46-f171-471f-bb69-fb55fff093d6","id":"02d26325-9147-4e6e-be20-58b05760040a"}],"animations":[{"id":"2d535ce0-b1ea-4b59-9afe-33fb43378ce5","type":"effect-fly-in","targets":["021e0541-35be-4946-80af-40b0a2d780a0"],"flyInDir":"bottomToTop","duration":1000,"delay":0},{"id":"538c7fcd-bee5-4355-94e6-0b52cd94e434","type":"effect-fly-in","targets":["29f9c85b-0182-4652-b798-11c76752ed53"],"flyInDir":"bottomToTop","duration":1000,"delay":200}],"type":"page","id":"b2cd7624-c3ec-4a7d-9867-d7d4dc8f0933","backgroundColor":{"color":{"r":33,"g":31,"b":30}},"pageTemplateType":"section","defaultBackgroundElement":{"x":21,"y":64,"width":128,"height":128,"type":"shape","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"mask":{"type":"rectangle"},"isBackground":true,"id":"f91f6bca-5c8c-45df-a9ff-172cfb58ae35","isDefaultBackground":true,"basedOn":"5249418e-8fb7-46d7-8af1-835671d52f2b"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/postgresql-commands\/?utm_source=Ib&utm_medium=postgresql-commands&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/PostgreSQL-Commands-2048x1000.png","needsProxy":false,"ctaText":"SWIPE UP"}}],"autoAdvance":true,"defaultPageDuration":7,"currentStoryStyles":{"colors":[]}},"style_presets":{"colors":[{"color":{"r":157,"g":100,"b":32}},{"color":{"r":0,"g":0,"b":0}}],"textStyles":[]},"story_poster":{"id":13748,"url":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/10\/cropped-PostGre-SQL-Commands.png","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13746"}],"collection":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story"}],"about":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/wp\/v2\/types\/web-story"}],"author":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/users\/21"}],"version-history":[{"count":8,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13746\/revisions"}],"predecessor-version":[{"id":13758,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13746\/revisions\/13758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media\/13748"}],"wp:attachment":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media?parent=13746"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web_story_category?post=13746"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web_story_tag?post=13746"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13746\/lock"}],"wp:publisherlogo":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media\/1082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}