On 7/10/22 12:47, Igor Korot wrote:
> So there is no "query" per se?
> Also how do I pass the table name?
>
> Thank you.
You can create one from the catalog tables. Personally, I would use
INFORMATION_SCHEMA to avoid pg_class and pg_attribute. However, there is
an extension which does that for you. Somebody else has already done the
hard work.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com