{"id":16966,"date":"2020-10-05T09:24:34","date_gmt":"2020-10-05T09:24:34","guid":{"rendered":"https:\/\/dbtut.com\/?p=16966"},"modified":"2020-10-06T11:36:07","modified_gmt":"2020-10-06T11:36:07","slug":"connect-to-postgres-from-command-line-in-windows","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/","title":{"rendered":"Connect To Postgres from command line in Windows"},"content":{"rendered":"

Sometimes you may need to connect to postgresql from command line in windows. In this article, I will show you how to do this.<\/p>\n

First, psql must be installed on your server. If you installed pgadmin, postgresql on the server you want to connect to, psql was installed with it. In this article, I will assume that you have installed pgadmin.<\/p>\n

We open the command line to connect to postgres and run the following command and go to the path where psql.exe is.<\/p>\n

c:\\Program Files (x86)\\pgAdmin 4\\v4\\runtime><\/pre>\n
After going to the path above, we list the files in it with the dir command.<\/p>\n
\"\"<\/p>\n
Connect To Postgres Database from command line in Windows<\/h3>\n
Now we see that we have a psql client, we can connect to postgres db from command line in windows as follows.<\/p>\n
psql -h localhost -U postgres<\/pre>\n
You may also want to read below articles;<\/p>\n
How To Connect To Database On PostgreSQL<\/a>,<\/p>\n
How To Create a Linked Server To Connect To PostgreSQL From SQL Server<\/a>,<\/p>\n
How To Find PostgreSQL lib and bin Directories,<\/a><\/p>\n
How To Stop, Start, Restart and Reload PostgreSQL Service<\/a><\/p>\n
Also you can find many article about Postgresql from below link.<\/p>\n
https:\/\/dbtut.com\/index.php\/category\/postgres\/<\/a><\/p>\n
If you want to read more about psql, open the below link.<\/p>\n
https:\/\/www.postgresql.org\/docs\/current\/app-psql.html<\/a><\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Sometimes you may need to connect to postgresql from command line in windows. In this article, I will show you how to do this. First, psql must be installed on your server. If you installed pgadmin, postgresql on the server you want to connect to, psql was installed with it. In this article, I will …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":16971,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[9986,9985,9987,9988,9989],"class_list":["post-16966","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-connect-to-postgres-database-command-line-windows","tag-connect-to-postgres-with-psql-in-windows","tag-postgresql-command-line-windows","tag-psql-command-line","tag-psql-connect-to-remote-database-command-line"],"aioseo_notices":[],"yoast_head":"\nConnect To Postgres from command line in Windows - Database Tutorials<\/title>\n<meta name=\"description\" content=\"We will connect to postgresql from command line in windows. Open windows command line and then go to the path where psql is locate.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect To Postgres from command line in Windows - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We will connect to postgresql from command line in windows. Open windows command line and then go to the path where psql is locate.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-05T09:24:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-06T11:36:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"812\" \/>\n\t<meta property=\"og:image:height\" content=\"498\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"Connect To Postgres from command line in Windows\",\"datePublished\":\"2020-10-05T09:24:34+00:00\",\"dateModified\":\"2020-10-06T11:36:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\"},\"wordCount\":225,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg\",\"keywords\":[\"connect to postgres database command line windows\",\"connect to postgres with psql in windows\",\"postgresql command line windows\",\"psql command line\",\"psql connect to remote database command line\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\",\"name\":\"Connect To Postgres from command line in Windows - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg\",\"datePublished\":\"2020-10-05T09:24:34+00:00\",\"dateModified\":\"2020-10-06T11:36:07+00:00\",\"description\":\"We will connect to postgresql from command line in windows. Open windows command line and then go to the path where psql is locate.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg\",\"width\":812,\"height\":498},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connect To Postgres from command line in Windows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect To Postgres from command line in Windows - Database Tutorials","description":"We will connect to postgresql from command line in windows. Open windows command line and then go to the path where psql is locate.","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:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/","og_locale":"en_US","og_type":"article","og_title":"Connect To Postgres from command line in Windows - Database Tutorials","og_description":"We will connect to postgresql from command line in windows. Open windows command line and then go to the path where psql is locate.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/","og_site_name":"Database Tutorials","article_published_time":"2020-10-05T09:24:34+00:00","article_modified_time":"2020-10-06T11:36:07+00:00","og_image":[{"width":812,"height":498,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg","type":"image\/jpeg"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"Connect To Postgres from command line in Windows","datePublished":"2020-10-05T09:24:34+00:00","dateModified":"2020-10-06T11:36:07+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/"},"wordCount":225,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg","keywords":["connect to postgres database command line windows","connect to postgres with psql in windows","postgresql command line windows","psql command line","psql connect to remote database command line"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/","url":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/","name":"Connect To Postgres from command line in Windows - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg","datePublished":"2020-10-05T09:24:34+00:00","dateModified":"2020-10-06T11:36:07+00:00","description":"We will connect to postgresql from command line in windows. Open windows command line and then go to the path where psql is locate.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/connectpostgrescommandline-1.jpg","width":812,"height":498},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/05\/connect-to-postgres-from-command-line-in-windows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Connect To Postgres from command line in Windows"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/16966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=16966"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/16966\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/16971"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=16966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=16966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=16966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}