Connecting pg_attribute with pg_namespace
Connecting pg_attribute with pg_namespace
От:
Igor Korot <ikorot01@gmail.com>
Дата:
Hi, How do I add schema name to [code] SELECT attnum FROM pg_attribute WHERE attrelid = 'my_table_name'; [/code] Thank you.
Re: Connecting pg_attribute with pg_namespace
От:
Ron Johnson <ronljohnsonjr@gmail.com>
Дата:
Join pg_attribute.attrelid to pg_class.oid and thus you have the table's relnamespace value.
On Sat, Oct 31, 2026 at 1:34 AM Igor Korot <ikorot01@gmail.com> 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 <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
Re: Connecting pg_attribute with pg_namespace
От:
Adrian Klaver <adrian.klaver@aklaver.com>
Дата:
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
Re: Connecting pg_attribute with pg_namespace
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Adrian Klaver writes: > On 10/31/26 3:04 PM, Igor Korot wrote: >> I have a schema name as a string. >> Should I cast that value to something when I write >> "pg_class.relnamespace = 'public'"? > select relname from pg_catalog.pg_class where relname = 'cell_per' and > relnamespace = 'public'::regnamespace; Given that the original requirement was >>> SELECT attnum FROM pg_attribute WHERE attrelid = 'my_table_name'; maybe just SELECT attnum FROM pg_attribute WHERE attrelid = 'my_schema_name.my_table_name'::regclass; ? But doing the joins explicitly is probably more adaptable to more-complex cases. regards, tom lane
Re: Connecting pg_attribute with pg_namespace
От:
Igor Korot <ikorot01@gmail.com>
Дата:
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'"? 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!
Re: Connecting pg_attribute with pg_namespace
От:
Igor Korot <ikorot01@gmail.com>
Дата:
On Sat, Oct 31, 2026 at 4:43 PM Adrian Klaver wrote: > > 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 > Thx. > > > > 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