Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xNGrW-00000002SEb-1iQR for pgsql-general@arkaria.postgresql.org; Sat, 31 Oct 2026 21:43:43 +0000 Received: from localhost ([127.0.0.1]:34124 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xNGrV-0000000Fgr9-2myZ for pgsql-general@arkaria.postgresql.org; Sat, 31 Oct 2026 21:43:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:34420) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xNGrU-0000000Fgr0-2I6q for pgsql-general@lists.postgresql.org; Sat, 31 Oct 2026 21:43:41 +0000 Received: from fout-a8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xNGrS-00000001uhl-29XM for pgsql-general@lists.postgresql.org; Sat, 31 Oct 2026 21:43:39 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id EF90DEC0605 for ; Sat, 31 Oct 2026 17:43:36 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Sat, 31 Oct 2026 17:43:36 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1793483016; x=1793569416; bh=VpxGriRDkC/3R2H3iFAaXYsJscZ9sJwQBGRTsbQ33Ek=; b= UeFqRB222ilkn+EwjFgFUyyHQO6wU1PPo/9BMcgXIUGEqg7TYyi0mi4zH68Gqmbw 8VgBOexuRdHfzCEo0qsyELDO32Zd+sQlThOySo/CbH6IOAQooqgBhkWle4iVpg+b FqzK2zBAG5fA0S/ej0FJ6xkuKBGiMwyP8+oivXqQ6a3W1iiENp5KTk+v5XAM/ew9 TGvbFiEFT6i2U0EQ0CXrAXziMPrybO+aLAbpdXhdjHqFsKh4RPpa0py+H8Y6ZRaC efKy96fAVZcLiSnq6YbwqDJ8Jqo4AmWTzERJin87ZK0vPpT5v1H0O+nk40ZslOjO enMDvQn+9Gp9NB3zD2mTTA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1793483016; x= 1793569416; bh=VpxGriRDkC/3R2H3iFAaXYsJscZ9sJwQBGRTsbQ33Ek=; b=k alzoLE7k8imNPiLq2Jp4qZet6PWVGnxxpL5IDSAfREbxYgqGA4QjMJmGuZiRjJTx /0l7fuNzowb2XinuEHZTEGmlt6IS/MTDH+xoSfAbWge9ywWrYBwBt8NaHmtJocsW iBx6utu6FDACJjNG2hGTL6AWBEQowTbcYzRel4CccDNCQS+w7B/+lrLCh/+iZ4U6 8/gEAeXVRUW6Vd+l3mk8d9l5Gkyc+zk+LHVgo16M/lDHD85K3kCf8bw9c0+1v/UL ly59+/NulJdPD+X9bYH6Bjp5De8TfQvb+QPQFqd1YfKA8esayyYYjWMXeR6BX/On 3FbvYallBtoHUt//l2Sww== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-08; repo=github.com/dkim2wg/interop; date=2026-10-28; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1793483016; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:tc8jZaP5CLM04K+ggftVLkR+wynJn9Z5y8Zh6B0L/UEdNm9 BbDS8nMah0tNZtic6HOtjaYdmfcb89P+2otJJ90TOlGezOK4tEExq71wah+TUnYF 9RLNew2Hj3Iawhfm5Kg6tdc8XypYuVDViicmCbVqBt7fgPJUlj7HOwc3gKGliM65 WaWe0zHtxI5Dy/Ed2T3rgeK+5gdsYNDRZAqcXfkaOrQSIlEktr4iqEVJUYcuMnW4 ReTgscjzpw3H3F+frEqfNNRPlzYST/FkpVMWzDg0E52FNr+PmqVWImfiiICmuyf3 y8NdF8LcSq7dLqmW1C2Lh0q0i89jfPOHdWAkVww==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-08; repo=github.com/dkim2wg/interop; date=2026-10-28; sw=lmtpprox; action=mi-m=1; hc=14; hn=cc,content-language,content-transfer-encoding,content-type, date,feedback-id,from,in-reply-to,message-id,mime-version, references,subject,to,user-agent; Message-Instance: m=1; h=sha256:BGnO9q8ZbNGf73qv9Yl1IZQna0icOLqWSsurQheLiW0=:WqXDbHPmc5C50UpYE41bNZlG6PDI5ZFVfXhqEf8v3nc=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEx/02hqQ08AwhkILQMqrXOIZqWgm1cfpidaiOQ+A3mJuMxTaRoNqpATvXR7MXLMv vn0Z9L+Ca7KxmFSZdyQGIv1Ee25vtDcS6eyiCIIdCfmFxc0xbT8IgztVhFfyrblm7jn4WW QqMQR+0bn5hzGzztPtzU5flMf+1+55SWlQrulllhf8UmRjKyhMqu9bncOkn/HaRhag02fL jdCOsKFwAV41OfE5Riik+elp5sF7CaZKyDnFqANXUvUx8jBPxC7ox8yFaegK6rZl74eTll kCrKiLrYHUYRnlQPlID0zslA0NfeSe59Xma6IJThqd5hBjXUxlBDlOM1Vr7RgWvo70UNiA 5pBk6/n7x9BPOXZu2tacxwyjsS/lVjlRl2cLD9km1SmCJvzNdHrlCdHY2ZPKGtzqJ6pH9Z js/2Ez5htzFO7DcLkwdUhdDsJ3J9DgB1Mi7ZXEegKZCIa2sbwQAvOn04YJUoTRA02BzNS4 gRAcYUTt+jZPyvwFIW1Ncp+aobK5IawQD1xsjDuvlhdf8FYBrSNUnykVk5d2/cIYX5APcp jxV2WtRvF4tMg5woNV94PHz0tLjAaqlWdXifdp9rPSk44b8ftSrpYxPD6vSEkSdO1vrqQ+ yIbPfD9U5xccehPl6a5/V9NpCfu1hGHRB9Tl30R8kek9HunlDKi9vmZ7obSQ X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 31 Oct 2026 17:43:36 -0400 (EDT) Message-ID: <92aca255-3ca3-4cb1-aec5-593b7eb3c275@aklaver.com> Date: Sat, 31 Oct 2026 14:43:35 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Connecting pg_attribute with pg_namespace To: Igor Korot , Ron Johnson Cc: "pgsql-generallists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/31/26 3:04 PM, Igor Korot wrote: > Hi, Ron, > > On Sat, Oct 31, 2026 at 1:24 AM Ron Johnson wrote: >> >> Join pg_attribute.attrelid to pg_class.oid and thus you have the table's relnamespace value. > > From the docs: > > [quote] > relnamespace oid (references pg_namespace.oid) > > The OID of the namespace that contains this relation > [/quote] > > I have a schema name as a string. > > Should I cast that value to something when I write > "pg_class.relnamespace = 'public'"? Take a look at this link below: https://www.postgresql.org/docs/current/datatype-oid.html It will make your like easier. So: select relname from pg_catalog.pg_class where relname = 'cell_per' and relnamespace = 'public'::regnamespace; relname ---------- cell_per > > Thank you. > >> >> On Sat, Oct 31, 2026 at 1:34 AM Igor Korot wrote: >>> >>> Hi, >>> How do I add schema name to >>> >>> [code] >>> SELECT attnum FROM pg_attribute WHERE attrelid = 'my_table_name'; >>> [/code] >>> >>> Thank you. >>> >>> >> >> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! > > -- Adrian Klaver adrian.klaver@aklaver.com