SELECT attrelid::regclass, * FROM pg_attribute WHERE atthasmissing;
-[ RECORD 1 ]-+---------
attrelid | download
attrelid | 22749
attname | filetype
atttypid | 1043
attstattarget | -1
attlen | -1
attnum | 5
attndims | 0
attcacheoff | -1
atttypmod | 36
attbyval | f
attstorage | x
attalign | i
attnotnull | t
atthasdef | t
atthasmissing | t
attidentity |
attisdropped | f
attislocal | t
attinhcount | 0
attcollation | 100
attacl |
attoptions |
attfdwoptions |
attmissingval | {csv}
On 4/9/20 2:31 PM, Justin Pryzby wrote:
> On Thu, Apr 09, 2020 at 02:05:22PM -0400, Tim Bishop wrote:
>> I've attached a file containing the \d+ for all the tables involved and the
>> EXPLAIN ANALYZE for the query.
>
> Thanks for your response.
>
> Do you know if you used the "fast default feature" ?
> That would happen if you did "ALTER TABLE tbl ADD col DEFAULT val"
>
> I guess this is the way to tell:
> SELECT attrelid::regclass, * FROM pg_attribute WHERE atthasmissing;
>