{"id":555,"date":"2026-05-03T13:00:17","date_gmt":"2026-05-03T16:00:17","guid":{"rendered":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/"},"modified":"2026-05-03T13:00:17","modified_gmt":"2026-05-03T16:00:17","slug":"aula-6-dml-basico-insert-select-update-e-delete-no-postgresq","status":"publish","type":"post","link":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/","title":{"rendered":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL"},"content":{"rendered":"<p>Bem-vindo \u00e0 Aula 6 do nosso curso &#8220;PostgreSQL \u2014 Do Zero ao Avan\u00e7ado&#8221;, onde voc\u00ea vai aprender sobre os comandos b\u00e1sicos de DML (Data Manipulation Language, ou Linguagem de Manipula\u00e7\u00e3o de Dados) no PostgreSQL. Compreender e ser capaz de utilizar esses comandos \u00e9 crucial para qualquer profissional de TI que lida com bancos de dados. Nesta aula, vamos explorar como inserir, selecionar, atualizar e deletar dados. Essas opera\u00e7\u00f5es s\u00e3o fundamentais para a gest\u00e3o de dados em qualquer aplica\u00e7\u00e3o.<\/p>\n<h3>O que voc\u00ea vai aprender nesta aula<\/h3>\n<ul>\n<li>Inserir dados usando o comando <strong>INSERT<\/strong>.<\/li>\n<li>Recuperar dados utilizando o comando <strong>SELECT<\/strong>.<\/li>\n<li>Atualizar dados com o comando <strong>UPDATE<\/strong>.<\/li>\n<li>Remover dados atrav\u00e9s do comando <strong>DELETE<\/strong>.<\/li>\n<\/ul>\n<h3>Entendendo o DML b\u00e1sico<\/h3>\n<p>O DML \u00e9 uma parte essencial do SQL (Structured Query Language, ou Linguagem de Consulta Estruturada) que permite modificar dados dentro de um banco de dados. Ao longo dos nossos projetos na JRT Technology Solutions, observamos que a efici\u00eancia na manipula\u00e7\u00e3o de dados \u00e9 vital para qualquer sistema. Vamos entender melhor cada um dos comandos de DML b\u00e1sico:<\/p>\n<ul>\n<li><strong>INSERT<\/strong>: usado para adicionar novas linhas em uma tabela.<\/li>\n<li><strong>SELECT<\/strong>: utilizado para consultar e recuperar dados de uma tabela.<\/li>\n<li><strong>UPDATE<\/strong>: serve para modificar dados existentes em uma tabela.<\/li>\n<li><strong>DELETE<\/strong>: utilizado para remover dados de uma tabela.<\/li>\n<\/ul>\n<h3>Praticando DML b\u00e1sico com exemplos<\/h3>\n<pre><code>\n-- Comando INSERT \nINSERT INTO alunos (nome, idade, curso) VALUES ('Jo\u00e3o Silva', 21, 'Engenharia');\n\n-- Comando SELECT \nSELECT * FROM alunos WHERE curso = 'Engenharia';\n\n-- Comando UPDATE \nUPDATE alunos SET idade = 22 WHERE nome = 'Jo\u00e3o Silva';\n\n-- Comando DELETE \nDELETE FROM alunos WHERE nome = 'Jo\u00e3o Silva';\n<\/code><\/pre>\n<p>Vamos detalhar o que cada linha faz:<\/p>\n<ul>\n<li><strong>INSERT<\/strong>: Estamos adicionando um novo registro \u00e0 tabela <strong>alunos<\/strong> com o nome &#8220;Jo\u00e3o Silva&#8221;, idade &#8220;21&#8221; e curso &#8220;Engenharia&#8221;.<\/li>\n<li><strong>SELECT<\/strong>: Este comando obt\u00e9m todos os alunos que est\u00e3o matriculados no curso de &#8220;Engenharia&#8221;.<\/li>\n<li><strong>UPDATE<\/strong>: Atualiza o campo idade do aluno &#8220;Jo\u00e3o Silva&#8221; para &#8220;22&#8221;.<\/li>\n<li><strong>DELETE<\/strong>: Remove o registro do aluno &#8220;Jo\u00e3o Silva&#8221; da tabela.<\/li>\n<\/ul>\n<h3>Mais sobre os comandos DML no PostgreSQL<\/h3>\n<p>Os comandos de DML s\u00e3o uma parte fundamental na intera\u00e7\u00e3o com um banco de dados. Em nossas implementa\u00e7\u00f5es na JRT Technology Solutions, garantir a integridade e precis\u00e3o na manipula\u00e7\u00e3o dos dados \u00e9 primordal. Note que, enquanto o <strong>INSERT<\/strong>, <strong>UPDATE<\/strong> e <strong>DELETE<\/strong> alteram os dados e podem impactar diretamente as informa\u00e7\u00f5es armazenadas, o <strong>SELECT<\/strong> serve apenas para ler dados.<\/p>\n<h3>Resumo da Aula 6<\/h3>\n<p>Nesta aula, aprendemos os conceitos b\u00e1sicos do DML: como inserir, selecionar, atualizar e deletar dados em um banco de dados PostgreSQL. Isso \u00e9 crucial para qualquer aplica\u00e7\u00e3o que manipula dados de maneira eficiente e segura. A pr\u00e1tica constante desses comandos em diferentes cen\u00e1rios vai otimizar seu trabalho no dia a dia. Na pr\u00f3xima aula, vamos explorar transa\u00e7\u00f5es no PostgreSQL e como utiliz\u00e1-las para garantir a integridade dos dados durante opera\u00e7\u00f5es complexas.<\/p>\n<div style=\"margin:48px 0 32px;padding:32px 24px;background:#f0fdf4;border:1px solid #bbf7d0;border-radius:16px;text-align:center;\">\n<p style=\"margin:0 0 8px;font-size:17px;color:#111827;font-weight:700;\">Quer aprender na pr\u00e1tica com especialistas?<\/p>\n<p style=\"margin:0 0 24px;font-size:15px;color:#1f2937;font-weight:400;\">A JRT Technology Solutions oferece treinamentos e implementa\u00e7\u00e3o de PostgreSQL para equipes corporativas.<\/p>\n<p>  <a href=\"https:\/\/api.whatsapp.com\/send\/?phone=5521980606699&#038;text=Ol%C3%A1%21+Tenho+interesse+no+treinamento+de+PostgreSQL.&#038;type=phone_number&#038;app_absent=0\"\n     target=\"_blank\" rel=\"noopener noreferrer\"\n     style=\"display:inline-flex;align-items:center;gap:12px;background:#25D366;color:#ffffff;font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',sans-serif;font-size:16px;font-weight:600;padding:14px 28px;border-radius:100px;text-decoration:none;box-shadow:0 4px 12px rgba(37,211,102,0.4);letter-spacing:0.01em;\"><br \/>\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"22\" height=\"22\" viewBox=\"0 0 24 24\" fill=\"#ffffff\">\n      <path d=\"M17.472 14.382c-.297-.149-1.758-.867-2.03-.967-.273-.099-.471-.148-.67.15-.197.297-.767.966-.94 1.164-.173.199-.347.223-.644.075-.297-.15-1.255-.463-2.39-1.475-.883-.788-1.48-1.761-1.653-2.059-.173-.297-.018-.458.13-.606.134-.133.298-.347.446-.52.149-.174.198-.298.298-.497.099-.198.05-.371-.025-.52-.075-.149-.669-1.612-.916-2.207-.242-.579-.487-.5-.669-.51-.173-.008-.371-.01-.57-.01-.198 0-.52.074-.792.372-.272.297-1.04 1.016-1.04 2.479 0 1.462 1.065 2.875 1.213 3.074.149.198 2.096 3.2 5.077 4.487.709.306 1.262.489 1.694.625.712.227 1.36.195 1.871.118.571-.085 1.758-.719 2.006-1.413.248-.694.248-1.289.173-1.413-.074-.124-.272-.198-.57-.347m-5.421 7.403h-.004a9.87 9.87 0 01-5.031-1.378l-.361-.214-3.741.982.998-3.648-.235-.374a9.86 9.86 0 01-1.51-5.26c.001-5.45 4.436-9.884 9.888-9.884 2.64 0 5.122 1.03 6.988 2.898a9.825 9.825 0 012.893 6.994c-.003 5.45-4.437 9.884-9.885 9.884m8.413-18.297A11.815 11.815 0 0012.05 0C5.495 0 .16 5.335.157 11.892c0 2.096.547 4.142 1.588 5.945L.057 24l6.305-1.654a11.882 11.882 0 005.683 1.448h.005c6.554 0 11.89-5.335 11.893-11.893a11.821 11.821 0 00-3.48-8.413z\"\/>\n    <\/svg><br \/>\n    Falar no WhatsApp<br \/>\n  <\/a>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"iawp_total_views":0,"footnotes":""},"categories":[75],"tags":[941,665,943,937,939],"class_list":["post-555","post","type-post","status-publish","format-standard","hentry","category-devops","tag-aprendizagem-sql","tag-comandos-sql","tag-linguagem-de-manipulacao-de-dados","tag-manipulacao-de-dados","tag-preparacao-de-banco-de-dados"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Thiago Paes Rodrigues\"\/>\n\t<meta name=\"google-site-verification\" content=\"QKPfpDCzHmzKyfFk5j1KZW3HhROYTPeqwBN5qcJ8qcg\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"BLOG - JRT Technology Solutions - Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta property=\"og:description\" content=\"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"100\" \/>\n\t\t<meta property=\"og:image:height\" content=\"75\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-05-03T16:00:17+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-05-03T16:00:17+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=61590814880509\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#blogposting\",\"name\":\"Aula 6: DML b\\u00e1sico \\u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions\",\"headline\":\"Aula 6: DML b\\u00e1sico \\u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL\",\"author\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/cropped-logo-mini.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#articleImage\",\"width\":100,\"height\":75},\"datePublished\":\"2026-05-03T13:00:17-03:00\",\"dateModified\":\"2026-05-03T13:00:17-03:00\",\"inLanguage\":\"pt-BR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#webpage\"},\"articleSection\":\"DevOps, aprendizagem SQL, comandos SQL, linguagem de manipula\\u00e7\\u00e3o de dados, manipula\\u00e7\\u00e3o de dados, prepara\\u00e7\\u00e3o de banco de dados\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jrtx.com.br\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"name\":\"DevOps\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"position\":2,\"name\":\"DevOps\",\"item\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#listItem\",\"name\":\"Aula 6: DML b\\u00e1sico \\u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#listItem\",\"position\":3,\"name\":\"Aula 6: DML b\\u00e1sico \\u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"name\":\"DevOps\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\",\"name\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"description\":\"Um espa\\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\\u00e1tica e atual. Aqui voc\\u00ea encontra novidades, an\\u00e1lises, tutoriais e reflex\\u00f5es sobre inova\\u00e7\\u00e3o, intelig\\u00eancia artificial, gadgets, programa\\u00e7\\u00e3o e tend\\u00eancias digitais. Nosso objetivo \\u00e9 simplificar o complexo, ajudar voc\\u00ea a se manter atualizado e transformar conhecimento em pr\\u00e1tica no seu dia a dia.\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/\",\"telephone\":\"+552138277513\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/cropped-logo-mini.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#organizationLogo\",\"width\":100,\"height\":75},\"image\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=61590814880509\",\"https:\\\/\\\/www.instagram.com\\\/jrtx.tech\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/\",\"name\":\"Thiago Paes Rodrigues\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cdfdf5f766c59d9c9acab959751c31c3442acd94d4b2927c51d2a0c31b50822?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Thiago Paes Rodrigues\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#webpage\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/\",\"name\":\"Aula 6: DML b\\u00e1sico \\u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions\",\"description\":\"Aprenda DML b\\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/03\\\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"datePublished\":\"2026-05-03T13:00:17-03:00\",\"dateModified\":\"2026-05-03T13:00:17-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/\",\"name\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"alternateName\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"description\":\"Um espa\\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\\u00e1tica e atual. Aqui voc\\u00ea encontra novidades, an\\u00e1lises, tutoriais e reflex\\u00f5es sobre inova\\u00e7\\u00e3o, intelig\\u00eancia artificial, gadgets, programa\\u00e7\\u00e3o e tend\\u00eancias digitais. Nosso objetivo \\u00e9 simplificar o complexo, ajudar voc\\u00ea a se manter atualizado e transformar conhecimento em pr\\u00e1tica no seu dia a dia.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions","description":"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!","canonical_url":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"QKPfpDCzHmzKyfFk5j1KZW3HhROYTPeqwBN5qcJ8qcg","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#blogposting","name":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions","headline":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL","author":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"publisher":{"@id":"https:\/\/jrtx.com.br\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","@id":"https:\/\/jrtx.com.br\/blog\/#articleImage","width":100,"height":75},"datePublished":"2026-05-03T13:00:17-03:00","dateModified":"2026-05-03T13:00:17-03:00","inLanguage":"pt-BR","mainEntityOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#webpage"},"isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#webpage"},"articleSection":"DevOps, aprendizagem SQL, comandos SQL, linguagem de manipula\u00e7\u00e3o de dados, manipula\u00e7\u00e3o de dados, prepara\u00e7\u00e3o de banco de dados"},{"@type":"BreadcrumbList","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","position":1,"name":"Home","item":"https:\/\/jrtx.com.br\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","name":"DevOps"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","position":2,"name":"DevOps","item":"https:\/\/jrtx.com.br\/blog\/category\/devops\/","nextItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#listItem","name":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#listItem","position":3,"name":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL","previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","name":"DevOps"}}]},{"@type":"Organization","@id":"https:\/\/jrtx.com.br\/blog\/#organization","name":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","description":"Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","url":"https:\/\/jrtx.com.br\/blog\/","telephone":"+552138277513","logo":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#organizationLogo","width":100,"height":75},"image":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=61590814880509","https:\/\/www.instagram.com\/jrtx.tech\/"]},{"@type":"Person","@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author","url":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/","name":"Thiago Paes Rodrigues","image":{"@type":"ImageObject","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cdfdf5f766c59d9c9acab959751c31c3442acd94d4b2927c51d2a0c31b50822?s=96&d=mm&r=g","width":96,"height":96,"caption":"Thiago Paes Rodrigues"}},{"@type":"WebPage","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#webpage","url":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/","name":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions","description":"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/#breadcrumblist"},"author":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"creator":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"datePublished":"2026-05-03T13:00:17-03:00","dateModified":"2026-05-03T13:00:17-03:00"},{"@type":"WebSite","@id":"https:\/\/jrtx.com.br\/blog\/#website","url":"https:\/\/jrtx.com.br\/blog\/","name":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","alternateName":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","description":"Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/jrtx.com.br\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"BLOG - JRT Technology Solutions - Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","og:type":"article","og:title":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions","og:description":"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!","og:url":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/","og:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","og:image:secure_url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","og:image:width":100,"og:image:height":75,"article:published_time":"2026-05-03T16:00:17+00:00","article:modified_time":"2026-05-03T16:00:17+00:00","article:publisher":"https:\/\/www.facebook.com\/profile.php?id=61590814880509","twitter:card":"summary_large_image","twitter:title":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL - BLOG - JRT Technology Solutions","twitter:description":"Aprenda DML b\u00e1sico com PostgreSQL! Domine comandos INSERT, SELECT, UPDATE e DELETE. Clique e transforme suas habilidades em gerenciamento de dados!","twitter:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg"},"aioseo_meta_data":{"post_id":"555","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"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_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"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":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-22 18:48:51","updated":"2026-06-22 18:48:51","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jrtx.com.br\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jrtx.com.br\/blog\/category\/devops\/\" title=\"DevOps\">DevOps<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tAula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/jrtx.com.br\/blog"},{"label":"DevOps","link":"https:\/\/jrtx.com.br\/blog\/category\/devops\/"},{"label":"Aula 6: DML b\u00e1sico \u2014 INSERT, SELECT, UPDATE e DELETE no PostgreSQL","link":"https:\/\/jrtx.com.br\/blog\/2026\/05\/03\/aula-6-dml-basico-insert-select-update-e-delete-no-postgresq\/"}],"_links":{"self":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/comments?post=555"}],"version-history":[{"count":0,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/555\/revisions"}],"wp:attachment":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media?parent=555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/categories?post=555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/tags?post=555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}