Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kpVX6-0004wf-5F for pgsql-admin@arkaria.postgresql.org; Wed, 16 Dec 2020 12:03:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kpVX5-0003FY-4r for pgsql-admin@arkaria.postgresql.org; Wed, 16 Dec 2020 12:03:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kpVX4-0003FR-TL for pgsql-admin@lists.postgresql.org; Wed, 16 Dec 2020 12:03:50 +0000 Received: from mail-qt1-x82b.google.com ([2607:f8b0:4864:20::82b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kpVX2-0004Og-Ua for pgsql-admin@lists.postgresql.org; Wed, 16 Dec 2020 12:03:50 +0000 Received: by mail-qt1-x82b.google.com with SMTP id 7so17003364qtp.1 for ; Wed, 16 Dec 2020 04:03:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=BY9XqenmnfmQikmR0TqPzgbXJ3RZCo6p6XiaO9Qmkqw=; b=moINxwLTpUjTb5yvs7dfX6i0MjpG+c9qw9sBJ8hp5rOHhqSgDtHAdSaDYPRG+QW+e/ JANaHDSjmonjlAHArxmUmEiyeYe1rNdAA7uh04Oo4H4fBJ0ois+tue/gfoG33qesRZRk K/TbF7Li94CKKPy0zyfaPcPWeC4SaXL1ynlifLt22ccVmZq5Ox12LT1LoekcOeOFhqlY Ldrvoo5K5N7LZJqeoyHlbmnQtdybbCRMWp82a8tEM47ByCRLM1GU5cWbuL3bTFXp0cPz noYdJtAskA9rJ35Kv5X27C/ej9EAOkpdxl08VuKZWFL0zupcizEgnGlxXNKdW2NID6wF 2XaA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=BY9XqenmnfmQikmR0TqPzgbXJ3RZCo6p6XiaO9Qmkqw=; b=ZXoZwdvKz+Sh3veBJ/yVG0LgUzoFl4r7yCQUfcQrynmGcICKSsX960OKWEgFtcr5tE SOP9cfzMJekGNc31dCvkSzdoZ8LPxWGawVru8SyzAgZj8yxxtvGuxWrdR63DpllLVvlN m2c2wtDERDWkxM2t4/BYWJAvN13YHN+pteDycH1oNrXavpy4uJJkW8otGWm68+eP6E+g E6FjSKpKpdZsao5rmyy3QaMbuce8qD3tJf0A2O0+MCRkh8fSjpen/0EmFY2YoQdqtWrk YbAznUbqx24IYJ7AKspYm8Xtoqr8Ds3ZVGpS/zZP6sRRKuNWYsAtSWaX5nnRaTEgthTT rNAw== X-Gm-Message-State: AOAM531apiJlnDpX1pxLJ/mh67y27R06zIYul4nV4MPqfpfXkSIwf9HK Jwvv3nixKG+5J1ijhXU7nRU= X-Google-Smtp-Source: ABdhPJwXPmP+vvbTZ0jnN4Nej41nTjss2dTG3T0r/QczuyRG5zMVsQrViWZ7oOjl2i3y+9kQ9v3I8w== X-Received: by 2002:ac8:4b48:: with SMTP id e8mr43647970qts.254.1608120226554; Wed, 16 Dec 2020 04:03:46 -0800 (PST) Received: from [192.168.254.67] (h178.165.133.40.static.ip.windstream.net. [40.133.165.178]) by smtp.gmail.com with ESMTPSA id f24sm885833qkk.89.2020.12.16.04.03.45 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 16 Dec 2020 04:03:45 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: Encrypt data in column Date: Wed, 16 Dec 2020 07:03:43 -0500 Message-Id: <64B117F2-897E-4216-BC35-F1B39DE17846@gmail.com> References: Cc: Pgsql-admin In-Reply-To: To: Yambu X-Mailer: iPad Mail (18B92) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Investigate using the pgcrypto extension, it should do exactly what you=E2=80= =99ve asked. =E2=80=94 Jay Sent from my iPad > On Dec 16, 2020, at 7:01 AM, Yambu wrote: >=20 > =EF=BB=BF > Hello >=20 > What ways can i encrypt columns with sensitive data in postgres? >=20 > regards