Connecting pg_attribute with pg_namespace

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Connecting pg_attribute with pg_namespace
Date: 2026-10-31 06:08:14
Message-ID: CA+FnnTxQm4ppiWvW018rJ9F8ZoiEJ7sXtFbNU-r=_92_cEtJUQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
How do I add schema name to

[code]
SELECT attnum FROM pg_attribute WHERE attrelid = 'my_table_name';
[/code]

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2026-10-31 06:24:10 Re: Connecting pg_attribute with pg_namespace
Previous Message Paul A Jungwirth 2026-10-30 22:34:40 Patch Review Workshop: November 2026