Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Andrew Dunstan <[EMAIL PROTECTED]> writes: >>> What is the approved way to iterate over a relation's attributes? >> >> Most places scan through the relation's tuple descriptor, rather >> than expending multiple catalog lookups in pg_attribute.
> Doesn't that require me to open the relation? Is that a good thing if I > wouldn't otherwise be doing that? Sure, because whatever work gets done is likely to be amortized across multiple uses of the relcache entry anyway. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings