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 <[email protected]> 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!
