{"id":8005,"date":"2026-07-24T17:09:19","date_gmt":"2026-07-24T10:09:19","guid":{"rendered":"https:\/\/www.cloudaja.id\/artikel\/?p=8005"},"modified":"2026-07-24T17:09:21","modified_gmt":"2026-07-24T10:09:21","slug":"uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data","status":"publish","type":"post","link":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/","title":{"rendered":"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">uuid-ossp dan pgcrypto merupakan dua extension penting di PostgreSQL<strong> <\/strong>yang banyak digunakan untuk membangun aplikasi modern. Saat merancang database, pemilihan primary key dan perlindungan data sensitif menjadi dua aspek penting. Dengan memanfaatkan extension <code>uuid-ossp<\/code> dan <code>pgcrypto<\/code>, PostgreSQL dapat menghasilkan UUID sebagai identifier unik serta menyediakan fitur hashing dan enkripsi untuk meningkatkan keamanan data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL menyediakan berbagai extension yang dapat memperluas fungsionalitas database tanpa memerlukan instalasi aplikasi tambahan. Di antaranya, <code>uuid-ossp<\/code> dan <code>pgcrypto<\/code> merupakan dua extension yang paling sering digunakan. Extension <code>uuid-ossp<\/code> berfungsi menghasilkan UUID (Universally Unique Identifier), sedangkan <code>pgcrypto<\/code> menyediakan berbagai fungsi kriptografi, seperti hashing password, enkripsi, dekripsi, hingga pembuatan UUID melalui fungsi <code>gen_random_uuid()<\/code> pada PostgreSQL versi modern.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pada artikel ini, Anda akan mempelajari cara mengaktifkan dan menggunakan extension <code>uuid-ossp<\/code> dan <code>pgcrypto<\/code>, memahami fungsi masing-masing, serta melihat contoh implementasinya dalam PostgreSQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sebelum memulai proses instalasi, penting untuk memahami fungsi masing-masing extension agar Anda dapat memilih solusi yang sesuai dengan kebutuhan aplikasi.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#1_Mengenal_Extension_uuid-ossp_di_PostgreSQL\" >1. Mengenal Extension uuid-ossp di PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#2_Mengenal_Extension_pgcrypto_di_PostgreSQL\" >2. Mengenal Extension pgcrypto di PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#3_Cara_Mengaktifkan_Extension_uuid-ossp_di_PostgreSQL\" >3. Cara Mengaktifkan Extension uuid-ossp di PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#4_Cara_Mengaktifkan_Extension_pgcrypto_di_PostgreSQL\" >4. Cara Mengaktifkan Extension pgcrypto di PostgreSQL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#Kesimpulan\" >Kesimpulan<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Mengenal_Extension_uuid-ossp_di_PostgreSQL\"><\/span>1. Mengenal Extension uuid-ossp di PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>uuid-ossp<\/code> merupakan extension PostgreSQL yang menyediakan berbagai fungsi untuk menghasilkan UUID (Universally Unique Identifier), yaitu identifier unik berukuran 128-bit yang mengikuti standar RFC 4122. UUID dirancang agar memiliki kemungkinan bentrok (<em>collision<\/em>) yang sangat kecil. Oleh karena itu, UUID cocok digunakan sebagai <em>primary key<\/em> atau identifier pada sistem terdistribusi yang berjalan di banyak server atau node. Selain itu, UUID memberikan keunikan secara global. Penggunaan UUID juga meningkatkan keamanan aplikasi karena nilai ID tidak bersifat berurutan seperti <code>1<\/code>, <code>2<\/code>, atau <code>3<\/code>. Hal ini dapat mengurangi risiko enumeration attack, yaitu upaya menebak atau melakukan scraping data melalui URL seperti <code>\/user\/1<\/code>, <code>\/user\/2<\/code>, dan seterusnya. Sebagai gantinya, UUID seperti <code>f47ac10b-58cc-4372-a567-0e02b2c3d479<\/code> jauh lebih sulit diprediksi sehingga membantu melindungi akses ke data dari percobaan yang tidak sah.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Mengenal_Extension_pgcrypto_di_PostgreSQL\"><\/span><strong>2. Mengenal Extension pgcrypto di PostgreSQL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>pgcrypto<\/code> merupakan extension PostgreSQL yang menyediakan berbagai fungsi kriptografi untuk meningkatkan keamanan data di dalam database. Extension ini memungkinkan Anda melakukan hashing password, enkripsi, dekripsi, serta menghasilkan nilai acak (<em>random<\/em>) yang dapat digunakan untuk berbagai kebutuhan aplikasi. Selain itu, pada PostgreSQL versi modern, <code>pgcrypto<\/code> juga menyediakan fungsi <code>gen_random_uuid()<\/code> untuk menghasilkan UUID versi 4. Oleh karena itu, extension ini sering menjadi pilihan dibandingkan <code>uuid-ossp<\/code> apabila hanya membutuhkan UUID acak. Dengan demikian, <code>pgcrypto<\/code> tidak hanya membantu mengamankan data sensitif seperti password, token, dan informasi penting lainnya, tetapi juga mendukung pembuatan UUID sesuai praktik terbaik yang direkomendasikan.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Cara_Mengaktifkan_Extension_uuid-ossp_di_PostgreSQL\"><\/span>3. Cara Mengaktifkan Extension uuid-ossp di PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"> Untuk mengaktifkan extension ini, jalankan perintah berikut pada database PostgreSQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah proses berhasil, Anda dapat memastikan extension telah terpasang dengan menjalankan:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"55\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-6-1024x55.png\" alt=\"\" class=\"wp-image-8010\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-6-1024x55.png 1024w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-6-300x16.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-6-768x41.png 768w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-6.png 1176w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM pg_extension;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Selanjutnya, jika proses instalasi berhasil, extension <code>uuid-ossp<\/code> akan muncul pada daftar extension yang terinstal.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"162\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-5-1024x162.png\" alt=\"\" class=\"wp-image-8009\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-5-1024x162.png 1024w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-5-300x47.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-5-768x121.png 768w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-5.png 1171w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah extension berhasil diaktifkan, Anda dapat menggunakannya untuk menghasilkan UUID sebagai nilai default pada kolom <code>primary key<\/code>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE users (\n    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),\n    name VARCHAR(100),\n    email VARCHAR(100)\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sebagai contoh, Anda dapat membuat tabel dan menambahkan data tanpa mengisi kolom <code>id<\/code> karena PostgreSQL akan menghasilkan UUID secara otomatis.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO users (name, email)\nVALUES ('Andi', 'andi@example.com');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Hasilnya akan terlihat seperti berikut:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"126\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-7.png\" alt=\"\" class=\"wp-image-8011\" style=\"width:522px;height:auto\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-7.png 748w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-7-300x51.png 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk mengetahui fungsi-fungsi UUID yang tersedia serta informasi lebih lengkap mengenai extension <code>uuid-ossp<\/code>, Anda dapat mengunjungi <a href=\"https:\/\/www.postgresql.org\/docs\/current\/uuid-ossp.html?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">UUID-OSSP Extension<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Cara_Mengaktifkan_Extension_pgcrypto_di_PostgreSQL\"><\/span><br>4. Cara Mengaktifkan Extension pgcrypto di PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Extension <code>pgcrypto<\/code> menyediakan berbagai fungsi kriptografi untuk meningkatkan keamanan data di PostgreSQL. Extension ini dapat digunakan untuk melakukan hashing password, enkripsi dan dekripsi data, serta menghasilkan UUID menggunakan fungsi <code>gen_random_uuid()<\/code> pada PostgreSQL versi modern.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk mengaktifkan extension, jalankan perintah berikut:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE EXTENSION IF NOT EXISTS pgcrypto;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah extension berhasil diaktifkan, <code>pgcrypto<\/code> dapat digunakan untuk mengenkripsi data menggunakan kunci tertentu.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT pgp_sym_encrypt('Data Rahasia', 'secret_key');<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"897\" height=\"233\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-8.png\" alt=\"\" class=\"wp-image-8012\" style=\"aspect-ratio:3.8501754637255603;width:531px;height:auto\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-8.png 897w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-8-300x78.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-8-768x199.png 768w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Selanjutnya, untuk mengembalikan data ke bentuk semula, gunakan fungsi dekripsi berikut.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT pgp_sym_decrypt(\n    pgp_sym_encrypt('Data Rahasia', 'secret_key'),\n    'secret_key'\n);<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"897\" height=\"233\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-9.png\" alt=\"\" class=\"wp-image-8013\" style=\"aspect-ratio:3.8501754637255603;width:527px;height:auto\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-9.png 897w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-9-300x78.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/image-9-768x199.png 768w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dengan memanfaatkan fitur-fitur tersebut, <code>pgcrypto<\/code> menjadi pilihan yang tepat untuk melindungi data sensitif di dalam database PostgreSQL, seperti password, token autentikasi, atau informasi penting lainnya. Jika ingin mempelajari fungsi hashing, enkripsi, dekripsi, dan fitur lain yang disediakan oleh <code>pgcrypto<\/code>, silakan merujuk ke <a href=\"https:\/\/www.postgresql.org\/docs\/current\/pgcrypto.html?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">pgcrypto Extension<\/a>.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kesimpulan\"><\/span>Kesimpulan<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Extension <code>uuid-ossp<\/code> dan <code>pgcrypto<\/code> merupakan dua extension penting di PostgreSQL untuk membangun aplikasi yang lebih aman dan andal. <code>uuid-ossp<\/code> digunakan untuk menghasilkan UUID sebagai identifier unik, sedangkan <code>pgcrypto<\/code> menyediakan berbagai fungsi kriptografi, seperti hashing, enkripsi, dan dekripsi untuk melindungi data sensitif. Dengan memanfaatkan kedua extension tersebut, Anda dapat meningkatkan keamanan sekaligus skalabilitas aplikasi yang dibangun menggunakan PostgreSQL. Selain itu, setelah proses konfigurasi selesai, Anda dapat mengelola database PostgreSQL melalui aplikasi DBeaver. Untuk panduan menghubungkan database menggunakan DBeaver, silakan baca artikel <a href=\"https:\/\/www.cloudaja.id\/artikel\/remote-database-menggunakan-dbeaver\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">Remote Database menggunakan DBeaver<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>uuid-ossp dan pgcrypto merupakan dua extension penting di PostgreSQL yang banyak digunakan untuk membangun aplikasi modern. Saat merancang database, pemilihan primary key dan perlindungan data sensitif menjadi dua aspek penting. Dengan memanfaatkan extension uuid-ossp dan pgcrypto, PostgreSQL dapat menghasilkan UUID sebagai identifier unik serta menyediakan fitur hashing dan enkripsi untuk meningkatkan keamanan data. PostgreSQL menyediakan [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":8023,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"seo_booster_metabox":"","footnotes":""},"categories":[37,202],"tags":[71,133,51],"class_list":["post-8005","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application","category-database","tag-database","tag-postgresql","tag-security"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data - CloudAja Artikel | Cloud Hosting Indonesia<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan uuid-ossp dan pgcrypto di PostgreSQL untuk membuat UUID, hashing password, dan mengenkripsi data dengan contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data - CloudAja Artikel | Cloud Hosting Indonesia\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan uuid-ossp dan pgcrypto di PostgreSQL untuk membuat UUID, hashing password, dan mengenkripsi data dengan contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudAja Artikel | Cloud Hosting Indonesia\" \/>\n<meta property=\"article:published_time\" content=\"2026-07-24T10:09:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-24T10:09:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/postgresql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Endryco Farel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Endryco Farel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/\"},\"author\":{\"name\":\"Endryco Farel\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/person\\\/f636c6aa2e67325a16b4860a6e027803\"},\"headline\":\"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data\",\"datePublished\":\"2026-07-24T10:09:19+00:00\",\"dateModified\":\"2026-07-24T10:09:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/\"},\"wordCount\":646,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/postgresql.png\",\"keywords\":[\"database\",\"postgresql\",\"security\"],\"articleSection\":[\"Application\",\"database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/\",\"name\":\"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data - CloudAja Artikel | Cloud Hosting Indonesia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/postgresql.png\",\"datePublished\":\"2026-07-24T10:09:19+00:00\",\"dateModified\":\"2026-07-24T10:09:21+00:00\",\"description\":\"Pelajari cara menggunakan uuid-ossp dan pgcrypto di PostgreSQL untuk membuat UUID, hashing password, dan mengenkripsi data dengan contoh.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/postgresql.png\",\"contentUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/postgresql.png\",\"width\":1536,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#website\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/\",\"name\":\"CloudAja Artikel | Cloud Hosting Indonesia\",\"description\":\"tips dan trik seputar Cloud Hosting Indonesia\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#organization\",\"name\":\"CloudAja Artikel | Cloud Hosting Indonesia\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/logo-cloudaja.resized.png\",\"contentUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/logo-cloudaja.resized.png\",\"width\":120,\"height\":81,\"caption\":\"CloudAja Artikel | Cloud Hosting Indonesia\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/person\\\/f636c6aa2e67325a16b4860a6e027803\",\"name\":\"Endryco Farel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9b6519e8add66a998112d53675fd187dd9172c644307c74746def3423021fa9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9b6519e8add66a998112d53675fd187dd9172c644307c74746def3423021fa9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9b6519e8add66a998112d53675fd187dd9172c644307c74746def3423021fa9?s=96&d=mm&r=g\",\"caption\":\"Endryco Farel\"},\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/author\\\/endryc0\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data - CloudAja Artikel | Cloud Hosting Indonesia","description":"Pelajari cara menggunakan uuid-ossp dan pgcrypto di PostgreSQL untuk membuat UUID, hashing password, dan mengenkripsi data dengan contoh.","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:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/","og_locale":"en_US","og_type":"article","og_title":"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data - CloudAja Artikel | Cloud Hosting Indonesia","og_description":"Pelajari cara menggunakan uuid-ossp dan pgcrypto di PostgreSQL untuk membuat UUID, hashing password, dan mengenkripsi data dengan contoh.","og_url":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/","og_site_name":"CloudAja Artikel | Cloud Hosting Indonesia","article_published_time":"2026-07-24T10:09:19+00:00","article_modified_time":"2026-07-24T10:09:21+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/postgresql.png","type":"image\/png"}],"author":"Endryco Farel","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Endryco Farel","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#article","isPartOf":{"@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/"},"author":{"name":"Endryco Farel","@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/person\/f636c6aa2e67325a16b4860a6e027803"},"headline":"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data","datePublished":"2026-07-24T10:09:19+00:00","dateModified":"2026-07-24T10:09:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/"},"wordCount":646,"commentCount":0,"publisher":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#organization"},"image":{"@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/postgresql.png","keywords":["database","postgresql","security"],"articleSection":["Application","database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/","url":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/","name":"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data - CloudAja Artikel | Cloud Hosting Indonesia","isPartOf":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#primaryimage"},"image":{"@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/postgresql.png","datePublished":"2026-07-24T10:09:19+00:00","dateModified":"2026-07-24T10:09:21+00:00","description":"Pelajari cara menggunakan uuid-ossp dan pgcrypto di PostgreSQL untuk membuat UUID, hashing password, dan mengenkripsi data dengan contoh.","breadcrumb":{"@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#primaryimage","url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/postgresql.png","contentUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2026\/07\/postgresql.png","width":1536,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.cloudaja.id\/artikel\/uuid-ossp-dan-pgcrypto-postgresql-uuid-enkripsi-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cloudaja.id\/artikel\/"},{"@type":"ListItem","position":2,"name":"uuid-ossp dan pgcrypto PostgreSQL: UUID &amp; Enkripsi Data"}]},{"@type":"WebSite","@id":"https:\/\/www.cloudaja.id\/artikel\/#website","url":"https:\/\/www.cloudaja.id\/artikel\/","name":"CloudAja Artikel | Cloud Hosting Indonesia","description":"tips dan trik seputar Cloud Hosting Indonesia","publisher":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cloudaja.id\/artikel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.cloudaja.id\/artikel\/#organization","name":"CloudAja Artikel | Cloud Hosting Indonesia","url":"https:\/\/www.cloudaja.id\/artikel\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/logo\/image\/","url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2022\/09\/logo-cloudaja.resized.png","contentUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2022\/09\/logo-cloudaja.resized.png","width":120,"height":81,"caption":"CloudAja Artikel | Cloud Hosting Indonesia"},"image":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/person\/f636c6aa2e67325a16b4860a6e027803","name":"Endryco Farel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b9b6519e8add66a998112d53675fd187dd9172c644307c74746def3423021fa9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b9b6519e8add66a998112d53675fd187dd9172c644307c74746def3423021fa9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b9b6519e8add66a998112d53675fd187dd9172c644307c74746def3423021fa9?s=96&d=mm&r=g","caption":"Endryco Farel"},"url":"https:\/\/www.cloudaja.id\/artikel\/author\/endryc0\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts\/8005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/comments?post=8005"}],"version-history":[{"count":8,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts\/8005\/revisions"}],"predecessor-version":[{"id":8021,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts\/8005\/revisions\/8021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/media\/8023"}],"wp:attachment":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/media?parent=8005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/categories?post=8005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/tags?post=8005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}