{"id":3385,"date":"2018-09-28T08:28:49","date_gmt":"2018-09-28T08:28:49","guid":{"rendered":"https:\/\/dbtut.com\/?p=3385"},"modified":"2018-11-24T21:02:41","modified_gmt":"2018-11-24T21:02:41","slug":"how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/","title":{"rendered":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>We may need to keep passwords in databases for some reason, and we don&#8217;t want anyone to see them, including dba.<\/p>\n<p>In postgresql there are several methods that we can use for this and one of them is extension, which is named chkpass.<\/p>\n<p>Chkpass is an extension. In order to use it, it is better to add contrib package during installation.<\/p>\n<p>In postgresql 10, contrib packages were merged.<\/p>\n<p>If you have installed Contrib packages, you can do the following operations.<\/p>\n<p>If you have not installed, you can read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\" target=\"_blank\" rel=\"noopener\"><span lang=\"tr\">How To Install <\/span><span lang=\"en-US\">PostgreSQL Replica<\/span><span lang=\"tr\">tion<\/span> <span lang=\"tr\">O<\/span><span lang=\"en-US\">n Centos<\/span><\/a>&#8220;.<\/p>\n<p>After connecting to the database to be processed, we execute the following command.<\/p>\n<p>To connect to the database, you can read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-database-on-postgresql\/\" target=\"_blank\" rel=\"noopener\">How To Connect To Database On PostgreSQL<\/a>&#8220;.<\/p>\n<pre class=\"lang:default decode:true \">CREATE EXTENSION chkpass;<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After installing the Extension, we create a table with chkpass type columns.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE staff (username varchar (100), chkpass password);<\/pre>\n<p>&nbsp;<\/p>\n<p>We&#8217;re loading data into the table for experiment purposes.<\/p>\n<pre class=\"lang:default decode:true \">insert into staff values (\u2019ssdd\u2019, \u20183333 values);<\/pre>\n<p>&nbsp;<\/p>\n<p>Check the data we loaded after making insert.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_2.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Our password field has been encrypted.<\/p>\n<p>Different encryption values will be generated even if each insert has the same data.<\/p>\n<p>The column can also be encrypted using the pgcrypto method.<\/p>\n<p>With pgcrypto method, we can also see the passwords by using the pgp_sym_decrypt method.<\/p>\n<p>But no one can see the data in the chkpass column.<\/p>\n<p>Only the pairing method can be used.<\/p>\n<p>To explain with an example;<\/p>\n<p>We can find the column of the above insert by matching it as follows.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_3.jpg\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3385\" class=\"pvc_stats all  \" data-element-id=\"3385\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; We may need to keep passwords in databases for some reason, and we don&#8217;t want anyone to see them, including dba. In postgresql there are several methods that we can use for this and one of them is extension, which is named chkpass. Chkpass is an extension. In order to use it, it is &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3385\" class=\"pvc_stats all  \" data-element-id=\"3385\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":0,"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":[],"class_list":["post-3385","post","type-post","status-publish","format-standard","","category-postgres"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Encrypt a Column(Like Password) with chkpass On PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL\" \/>\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\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-28T08:28:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-24T21:02:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png\" \/>\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\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL\",\"datePublished\":\"2018-09-28T08:28:49+00:00\",\"dateModified\":\"2018-11-24T21:02:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\"},\"wordCount\":259,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\",\"name\":\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png\",\"datePublished\":\"2018-09-28T08:28:49+00:00\",\"dateModified\":\"2018-11-24T21:02:41+00:00\",\"description\":\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage\",\"url\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png\",\"contentUrl\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL\"}]},{\"@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":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL - Database Tutorials","description":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL","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\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL - Database Tutorials","og_description":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL","og_url":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2018-09-28T08:28:49+00:00","article_modified_time":"2018-11-24T21:02:41+00:00","og_image":[{"url":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png","type":"","width":"","height":""}],"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\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL","datePublished":"2018-09-28T08:28:49+00:00","dateModified":"2018-11-24T21:02:41+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/"},"wordCount":259,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/","name":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png","datePublished":"2018-09-28T08:28:49+00:00","dateModified":"2018-11-24T21:02:41+00:00","description":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#primaryimage","url":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png","contentUrl":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/09\/chkpass_1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/28\/how-to-encrypt-a-columnlike-password-with-chkpass-on-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Encrypt a Column(Like Password) with chkpass On PostgreSQL"}]},{"@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\/3385","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=3385"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3385\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}