{"id":8018,"date":"2024-07-16T12:07:57","date_gmt":"2024-07-16T06:37:57","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=8018"},"modified":"2024-07-16T12:07:59","modified_gmt":"2024-07-16T06:37:59","slug":"how-to-connect-the-postgres-db-using-terminal-and-ui","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/","title":{"rendered":"How to connect the Postgres DB using Terminal and UI"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><strong>Introduction :<\/strong> <\/h3>\n\n\n\n<p>PostgreSQL, commonly known as Postgres, is a powerful open-source relational database management system. It excels in data integrity, extensibility, and compliance with SQL standards. Postgres is widely utilized for handling complex and high-performance database applications. Its active community and continuous development.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisites:<\/h3>\n\n\n\n<p><strong>PostgreSQL Installed<\/strong>: Ensure PostgreSQL is installed on your system. You can download it from the <a href=\"https:\/\/www.postgresql.org\/download\/\">official PostgreSQL website<\/a>.<\/p>\n\n\n\n<p><strong>Access Credentials<\/strong>: You need the following details to connect:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Host<\/strong>: The server address where your PostgreSQL instance is hosted (e.g., <code>localhost<\/code> or an IP address).<\/li>\n\n\n\n<li><strong>Port<\/strong>: The port on which your PostgreSQL server is listening (default is <code>5432<\/code>).<\/li>\n\n\n\n<li><strong>Database Name<\/strong>: The name of the database you want to connect to.<\/li>\n\n\n\n<li><strong>Username<\/strong>: Your PostgreSQL username.<\/li>\n\n\n\n<li><strong>Password<\/strong>: Your PostgreSQL password.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Connect using Terminal<\/h2>\n\n\n\n<p><strong>Connect Using psql<\/strong>: Use the following command to connect to your PostgreSQL server:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ psql -h &amp;lt;host&amp;gt; -p &amp;lt;port&amp;gt; -d &amp;lt;database_name&amp;gt; -U &amp;lt;username&amp;gt;\n<\/pre><\/div>\n\n\n<p>Replace <code>&lt;host&gt;<\/code>, <code>&lt;port&gt;<\/code>, <code>&lt;database_name&gt;<\/code>, and <code>&lt;username&gt;<\/code> with your actual PostgreSQL connection details.<\/p>\n\n\n\n<p><strong>Enter Password<\/strong>: After running the above command, you will be prompted to enter your password. Enter your PostgreSQL password and press Enter.<\/p>\n\n\n\n<p>If the connection is successful, you should see the PostgreSQL prompt<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"885\" height=\"84\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png\" alt=\"\" class=\"wp-image-8019\" style=\"width:840px;height:auto\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png 885w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-300x28.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-768x73.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-850x81.png 850w\" sizes=\"auto, (max-width: 885px) 100vw, 885px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Connect using UI<\/h2>\n\n\n\n<p>The first time you open pgAdmin, you need to set up the server so the app knows where to connect. <br>Click Add New Server. <br>The create server screen will open.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"885\" height=\"702\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-1.png\" alt=\"\" class=\"wp-image-8020\" style=\"width:505px;height:auto\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-1.png 885w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-1-300x238.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-1-768x609.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-1-378x300.png 378w\" sizes=\"auto, (max-width: 885px) 100vw, 885px\" \/><\/a><\/figure>\n\n\n\n<p>When you\u2019ve finished, click the Connection tab at the top.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"503\" height=\"558\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-2.png\" alt=\"\" class=\"wp-image-8021\" style=\"width:455px;height:auto\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-2.png 503w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-2-270x300.png 270w\" sizes=\"auto, (max-width: 503px) 100vw, 503px\" \/><\/a><\/figure>\n\n\n\n<p>Use the fields in the Connection tab to configure a connection:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the IP address or server hostname you wish to connect to. For example, this could be the IP address 1.2.3.4 or a server hostname, like server.serverhostgroup.com.<\/li>\n\n\n\n<li>Enter the listener port number of the server host in the Port field. The default is 5432.<\/li>\n\n\n\n<li>The maintenance DB field is used to specify the initial database that pgAdmin connects to DB (optional).<\/li>\n\n\n\n<li>Use the Username field to specify the username assigned to the database you\u2019re connecting to.<\/li>\n\n\n\n<li>Use the Password field to provide a password that goes with your database user account.<\/li>\n\n\n\n<li>Check the box next to Save password? to instruct pgAdmin to save the password for future use if you want.<\/li>\n<\/ul>\n\n\n\n<p>When you\u2019ve finished, click Save. The pgAdmin app will attempt to connect to the server automatically, and the settings will be changed so the next time you open pgAdmin, you\u2019ll be able to connect easily.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"782\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3-1024x782.png\" alt=\"\" class=\"wp-image-8022\" style=\"width:558px;height:auto\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3-1024x782.png 1024w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3-300x229.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3-768x586.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3-393x300.png 393w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image-3.png 1187w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/chemicloud.com\/kb\/storage\/2021\/04\/115.png\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction : PostgreSQL, commonly known as Postgres, is a powerful open-source relational database management system. It excels in data integrity, extensibility, and compliance with SQL standards. Postgres is widely utilized for handling complex and high-performance database applications. Its active community and continuous development. Prerequisites: PostgreSQL Installed: Ensure PostgreSQL is installed&hellip; <a href=\"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/\" class=\"more-link read-more\" rel=\"bookmark\">Continue Reading <span class=\"screen-reader-text\">How to connect the Postgres DB using Terminal and UI<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":509,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-8018","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-uncategorized","7":"h-entry","9":"h-as-article"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Pheonix Solutions - We Empower Your Business Growth<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"Introduction : PostgreSQL, commonly known as Postgres, is a powerful open-source relational database management system. It excels in data integrity, extensibility, and compliance with SQL standards. Postgres is widely utilized for handling complex and high-performance database applications. Its active community and continuous development. Prerequisites: PostgreSQL Installed: Ensure PostgreSQL is installed&hellip; Continue Reading How to connect the Postgres DB using Terminal and UI\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-16T06:37:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-16T06:37:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png\" \/>\n<meta name=\"author\" content=\"ajith kumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ajith kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/\"},\"author\":{\"name\":\"ajith kumar\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/6ab408ebbf9dfadd98efe97ac6a1628c\"},\"headline\":\"How to connect the Postgres DB using Terminal and UI\",\"datePublished\":\"2024-07-16T06:37:57+00:00\",\"dateModified\":\"2024-07-16T06:37:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/\"},\"wordCount\":389,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\",\"datePublished\":\"2024-07-16T06:37:57+00:00\",\"dateModified\":\"2024-07-16T06:37:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#primaryimage\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\",\"width\":885,\"height\":84},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-connect-the-postgres-db-using-terminal-and-ui\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to connect the Postgres DB using Terminal and UI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/6ab408ebbf9dfadd98efe97ac6a1628c\",\"name\":\"ajith kumar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a463c141c3488471a039f0a4d588a86bc78219e706133ac827f260f60ee9dc83?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a463c141c3488471a039f0a4d588a86bc78219e706133ac827f260f60ee9dc83?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a463c141c3488471a039f0a4d588a86bc78219e706133ac827f260f60ee9dc83?s=96&r=g\",\"caption\":\"ajith kumar\"},\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/ajithkumar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"Introduction : PostgreSQL, commonly known as Postgres, is a powerful open-source relational database management system. It excels in data integrity, extensibility, and compliance with SQL standards. Postgres is widely utilized for handling complex and high-performance database applications. Its active community and continuous development. Prerequisites: PostgreSQL Installed: Ensure PostgreSQL is installed&hellip; Continue Reading How to connect the Postgres DB using Terminal and UI","og_url":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2024-07-16T06:37:57+00:00","article_modified_time":"2024-07-16T06:37:59+00:00","og_image":[{"url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png","type":"","width":"","height":""}],"author":"ajith kumar","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"ajith kumar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/"},"author":{"name":"ajith kumar","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/6ab408ebbf9dfadd98efe97ac6a1628c"},"headline":"How to connect the Postgres DB using Terminal and UI","datePublished":"2024-07-16T06:37:57+00:00","dateModified":"2024-07-16T06:37:59+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/"},"wordCount":389,"commentCount":0,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#primaryimage"},"thumbnailUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/","url":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#primaryimage"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#primaryimage"},"thumbnailUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png","datePublished":"2024-07-16T06:37:57+00:00","dateModified":"2024-07-16T06:37:59+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#primaryimage","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2024\/07\/image.png","width":885,"height":84},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-connect-the-postgres-db-using-terminal-and-ui\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to connect the Postgres DB using Terminal and UI"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/6ab408ebbf9dfadd98efe97ac6a1628c","name":"ajith kumar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a463c141c3488471a039f0a4d588a86bc78219e706133ac827f260f60ee9dc83?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a463c141c3488471a039f0a4d588a86bc78219e706133ac827f260f60ee9dc83?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a463c141c3488471a039f0a4d588a86bc78219e706133ac827f260f60ee9dc83?s=96&r=g","caption":"ajith kumar"},"url":"https:\/\/pheonixsolutions.com\/blog\/author\/ajithkumar\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-25k","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/509"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=8018"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8018\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=8018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=8018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=8018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}