Greg Stark escribió:
row_number() over (partition by T.schemaname,T.viewname order by
attnum) as "ORDINAL_POSITION"
On Wed, Nov 25, 2009 at 1:03 AM, Konstantin Izmailov wrote:
My question: can pg_attribute.attnum be used to determine the sequential
ordinal positions of columns in a table? What is a right way to get the
ordinal numbers?
You could use something like:My question: can pg_attribute.attnum be used to determine the sequential
ordinal positions of columns in a table? What is a right way to get the
ordinal numbers?
row_number() over (partition by T.schemaname,T.viewname order by
attnum) as "ORDINAL_POSITION"
I notice they still use attnum.