{"id":488,"date":"2025-08-27T12:48:48","date_gmt":"2025-08-27T15:48:48","guid":{"rendered":"https:\/\/www.kinghost.com.br\/wiki\/?post_type=article&#038;p=488"},"modified":"2025-08-27T12:48:49","modified_gmt":"2025-08-27T15:48:49","slug":"postgre-via-pgadmin","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/","title":{"rendered":"Como acessar um banco Postgre via pgAdmin"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Precisa acessar um banco de dados postgre via pgadmin? Confira mais detalhes logo abaixo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Que tal ouvir este conte\u00fado? \u00c9 s\u00f3 dar o play!<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><p><\/p><iframe width=\"100%\" height=\"83\" scrolling=\"no\" data-src=\"https:\/\/go.vooozer.com\/embed\/fabc0a16\" frameborder=\"0\" title=\"Narra\u00e7\u00e3o humana do artigo\" style=\"height: 83px !important;\" allowfullscreen=\"\" src=\"about:blank\" class=\"lazyload\" data-load-mode=\"0\"><\/iframe><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">O pgAdmin est\u00e1 dispon\u00edvel para Windows, Mac e Linux.<br>Acesse <a href=\"http:\/\/www.postgresql.org\/ftp\/pgadmin3\/release\/\" target=\"_blank\" rel=\"noopener\">postgresql.org\/release<\/a>, a fim de baixar o programa.<br>Para isso, acesse a pasta com vers\u00e3o mais recente do software e efetue o download.<br>Fa\u00e7a a instala\u00e7\u00e3o em seu computador. Voc\u00ea precisa ter privil\u00e9gios de administrador em sua m\u00e1quina para poder instal\u00e1-lo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/king.host\/?utm_source=wiki&amp;utm_medium=banner-artigo&amp;utm_campaign=banner-artigo-wiki-awareness-postgre-via-pgadmin\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-original=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1.png\" alt=\"banner-kinghost\" class=\"wp-image-25436\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Configurando_a_conexao_com_o_Postgre_via_pgAdmin\"><\/span>Configurando a conex\u00e3o com o Postgre via pgAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Com o pgAdmin aberto, clique no menu <strong>File<\/strong> e depois na op\u00e7\u00e3o <strong>Add Server&#8230;<\/strong>;<br>Surgir\u00e1 um janela entitulada <em>New Server Registration<\/em>, \u00e9 nela que voc\u00ea definir inserir os dados para conex\u00e3o.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Precisa obter os dados de acesso ao seu banco de dados? Acesse o artigo <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/verificar-dados-de-acesso-do-seu-banco-de-dados\/\" target=\"_blank\" rel=\"noopener\">Onde encontrar os dados de acesso ao banco de dados<\/a>. Se necess\u00e1rio, acesse o artigo <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/alterar-senha-de-uma-base-de-dados\/\" target=\"_blank\" rel=\"noopener\">Trocar senha do banco de dados<\/a> para saber mais sobre a altera\u00e7\u00e3o de senha de uma base de dados.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2015\/05\/pgamin0001.png\" alt=\"Conex\u00e3o pgAdmin\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Confira como preencher de acordo com a imagem abaixo:<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fazendo_a_conexao_com_a_base\"><\/span>Fazendo a conex\u00e3o com a base<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2015\/05\/pgadmin0002.png\" alt=\"postgre via pgadmin\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Ao lado esquerdo do painel do pgAdmin, d\u00ea um duplo clique em <strong>Server Groups<\/strong> e clique no banco de dados que acabou de configurar.<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Depois, basta manipular sua base de dados de acordo com sua necessidade.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Aconteceu algum erro ao tentar acessa sua base de dados?<\/strong> D\u00ea uma olhada neste artigo: <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/fatal-no-pg-hba-conf-entry-for-host\/\" target=\"_blank\" rel=\"noopener\" title=\"\">no pg_hba.conf entry for host<\/a>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Conforme visto acima, a conex\u00e3o \u00e0 bancos pgsql pode ser facilitada atrav\u00e9s do aplicativo pgAdmin. Entretanto, tamb\u00e9m \u00e9 poss\u00edvel acessar sua base postgre via navegador. Veja: <a href=\"https:\/\/king.host\/wiki\/artigo\/como-acessar-uma-base-de-dados-via-web\/\" target=\"_blank\" rel=\"noopener\">Como acessar uma base de dados via web<\/a>.<\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[11],"article-tag":[],"class_list":["post-488","article","type-article","status-publish","format-standard","hentry","article-category-banco-de-dados"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"teste.andre\"\/>\n\t<meta name=\"google-site-verification\" content=\"ofqjo5zOS5ZIGtLClOeuFS3sGuOFAUlE6pyxkKJuj8w\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Central de Ajuda KingHost - Central de Ajuda KingHost\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Como acessar um banco Postgre via pgAdmin - kingHost\" \/>\n\t\t<meta property=\"og:description\" content=\"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/08\/central-de-ajuda-kinghost.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/08\/central-de-ajuda-kinghost.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2025-08-27T15:48:48+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-08-27T15:48:49+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/KingHost.Brasil\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@kinghost\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Como acessar um banco Postgre via pgAdmin - kingHost\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@kinghost\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/08\/central-de-ajuda-kinghost.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki#listItem\",\"position\":1,\"name\":\"In\\u00edcio\",\"item\":\"https:\\\/\\\/king.host\\\/wiki\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/hospedagem\\\/#listItem\",\"name\":\"Hospedagem\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/hospedagem\\\/#listItem\",\"position\":2,\"name\":\"Hospedagem\",\"item\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/hospedagem\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/banco-de-dados\\\/#listItem\",\"name\":\"Banco de dados\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki#listItem\",\"name\":\"In\\u00edcio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/banco-de-dados\\\/#listItem\",\"position\":3,\"name\":\"Banco de dados\",\"item\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/banco-de-dados\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#listItem\",\"name\":\"Como acessar um banco Postgre via pgAdmin\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/hospedagem\\\/#listItem\",\"name\":\"Hospedagem\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#listItem\",\"position\":4,\"name\":\"Como acessar um banco Postgre via pgAdmin\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/base-de-conhecimento\\\/banco-de-dados\\\/#listItem\",\"name\":\"Banco de dados\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/#organization\",\"name\":\"kingHost Hospedagem de Sites\",\"description\":\"Central de Ajuda KingHost\",\"url\":\"https:\\\/\\\/king.host\\\/wiki\\\/\",\"telephone\":\"+5551996659627\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/king.host\\\/wiki\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/kinghost.png\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#organizationLogo\",\"width\":377,\"height\":73},\"image\":{\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/KingHost.Brasil\",\"https:\\\/\\\/twitter.com\\\/kinghost\",\"https:\\\/\\\/www.instagram.com\\\/kinghost\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UC41tI4JaVY8rde3XnM2S4mw\",\"https:\\\/\\\/br.linkedin.com\\\/company\\\/kinghost\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/author\\\/andre-santos\\\/#author\",\"url\":\"https:\\\/\\\/king.host\\\/wiki\\\/author\\\/andre-santos\\\/\",\"name\":\"teste.andre\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0be41e3058e57314366aa7797c6ac15d0e4ddcaea62bf3ab0028f3ace791221?s=96&d=https%3A%2F%2Fking.host%2Fwiki%2Fwp-content%2Fuploads%2F2018%2F05%2Ftime-marketing-avatar.jpeg&r=g\",\"width\":96,\"height\":96,\"caption\":\"teste.andre\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#webpage\",\"url\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/\",\"name\":\"Como acessar um banco Postgre via pgAdmin - kingHost\",\"description\":\"Neste artigo voc\\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \\u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/artigo\\\/postgre-via-pgadmin\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/author\\\/andre-santos\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/author\\\/andre-santos\\\/#author\"},\"datePublished\":\"2025-08-27T12:48:48-03:00\",\"dateModified\":\"2025-08-27T12:48:49-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/#website\",\"url\":\"https:\\\/\\\/king.host\\\/wiki\\\/\",\"name\":\"Central de Ajuda KingHost\",\"description\":\"Central de Ajuda KingHost\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/king.host\\\/wiki\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Como acessar um banco Postgre via pgAdmin - kingHost","description":"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.","canonical_url":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"ofqjo5zOS5ZIGtLClOeuFS3sGuOFAUlE6pyxkKJuj8w","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/king.host\/wiki#listItem","position":1,"name":"In\u00edcio","item":"https:\/\/king.host\/wiki","nextItem":{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/base-de-conhecimento\/hospedagem\/#listItem","name":"Hospedagem"}},{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/base-de-conhecimento\/hospedagem\/#listItem","position":2,"name":"Hospedagem","item":"https:\/\/king.host\/wiki\/base-de-conhecimento\/hospedagem\/","nextItem":{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/base-de-conhecimento\/banco-de-dados\/#listItem","name":"Banco de dados"},"previousItem":{"@type":"ListItem","@id":"https:\/\/king.host\/wiki#listItem","name":"In\u00edcio"}},{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/base-de-conhecimento\/banco-de-dados\/#listItem","position":3,"name":"Banco de dados","item":"https:\/\/king.host\/wiki\/base-de-conhecimento\/banco-de-dados\/","nextItem":{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#listItem","name":"Como acessar um banco Postgre via pgAdmin"},"previousItem":{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/base-de-conhecimento\/hospedagem\/#listItem","name":"Hospedagem"}},{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#listItem","position":4,"name":"Como acessar um banco Postgre via pgAdmin","previousItem":{"@type":"ListItem","@id":"https:\/\/king.host\/wiki\/base-de-conhecimento\/banco-de-dados\/#listItem","name":"Banco de dados"}}]},{"@type":"Organization","@id":"https:\/\/king.host\/wiki\/#organization","name":"kingHost Hospedagem de Sites","description":"Central de Ajuda KingHost","url":"https:\/\/king.host\/wiki\/","telephone":"+5551996659627","logo":{"@type":"ImageObject","url":"https:\/\/king.host\/wiki\/wp-content\/uploads\/2021\/09\/kinghost.png","@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#organizationLogo","width":377,"height":73},"image":{"@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/KingHost.Brasil","https:\/\/twitter.com\/kinghost","https:\/\/www.instagram.com\/kinghost\/","https:\/\/www.youtube.com\/channel\/UC41tI4JaVY8rde3XnM2S4mw","https:\/\/br.linkedin.com\/company\/kinghost"]},{"@type":"Person","@id":"https:\/\/king.host\/wiki\/author\/andre-santos\/#author","url":"https:\/\/king.host\/wiki\/author\/andre-santos\/","name":"teste.andre","image":{"@type":"ImageObject","@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/b0be41e3058e57314366aa7797c6ac15d0e4ddcaea62bf3ab0028f3ace791221?s=96&d=https%3A%2F%2Fking.host%2Fwiki%2Fwp-content%2Fuploads%2F2018%2F05%2Ftime-marketing-avatar.jpeg&r=g","width":96,"height":96,"caption":"teste.andre"}},{"@type":"WebPage","@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#webpage","url":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/","name":"Como acessar um banco Postgre via pgAdmin - kingHost","description":"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/king.host\/wiki\/#website"},"breadcrumb":{"@id":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/#breadcrumblist"},"author":{"@id":"https:\/\/king.host\/wiki\/author\/andre-santos\/#author"},"creator":{"@id":"https:\/\/king.host\/wiki\/author\/andre-santos\/#author"},"datePublished":"2025-08-27T12:48:48-03:00","dateModified":"2025-08-27T12:48:49-03:00"},{"@type":"WebSite","@id":"https:\/\/king.host\/wiki\/#website","url":"https:\/\/king.host\/wiki\/","name":"Central de Ajuda KingHost","description":"Central de Ajuda KingHost","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/king.host\/wiki\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"Central de Ajuda KingHost - Central de Ajuda KingHost","og:type":"article","og:title":"Como acessar um banco Postgre via pgAdmin - kingHost","og:description":"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.","og:url":"https:\/\/king.host\/wiki\/artigo\/postgre-via-pgadmin\/","og:image":"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/08\/central-de-ajuda-kinghost.png","og:image:secure_url":"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/08\/central-de-ajuda-kinghost.png","og:image:width":1920,"og:image:height":1080,"article:published_time":"2025-08-27T15:48:48+00:00","article:modified_time":"2025-08-27T15:48:49+00:00","article:publisher":"https:\/\/www.facebook.com\/KingHost.Brasil","twitter:card":"summary_large_image","twitter:site":"@kinghost","twitter:title":"Como acessar um banco Postgre via pgAdmin - kingHost","twitter:description":"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.","twitter:creator":"@kinghost","twitter:image":"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/08\/central-de-ajuda-kinghost.png"},"aioseo_meta_data":{"post_id":"488","title":null,"description":"Neste artigo voc\u00ea confere como pode acessar um banco de dados Postgre via pgAdmin. O PgAdmin \u00e9 o aplicativo mais popular para gerenciamento de bases pgsql.","keywords":null,"keyphrases":{"focus":{"keyphrase":"postgre via pgadmin","analysis":{"keyphraseInTitle":{"score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"score":9,"maxScore":9,"error":0},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":3},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"score":9,"maxScore":9,"error":0},"keyphraseInImageAlt":{"score":9,"maxScore":9,"error":0},"keywordDensity":{"type":"best","score":9,"maxScore":9,"error":0}},"score":100},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2021-05-12 13:37:13","updated":"2026-07-20 15:20:16","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/comments?post=488"}],"version-history":[{"count":9,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/488\/revisions"}],"predecessor-version":[{"id":26973,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/488\/revisions\/26973"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=488"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=488"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}