On 3/13/21 1:05 PM, Ulrich Goebel wrote:
I would like to get the rows, where a column has the default value, similar to: select id fromt tbl where col = default Is there a chance?
It isn't pretty, and not all that practical, but for example: 8<-------------------- create table def(id int, f1 text not null default 'foo'); insert into def values(1,'hello'),(2,default),(3,default),(4,'bar'); SELECT * FROM def WHERE $$'$$ || f1 || $$'::text$$ = (SELECT pg_get_expr(d.adbin, d.adrelid, true) FROM pg_attrdef d JOIN pg_attribute a on d.adrelid = a.attrelid AND d.adnum = a.attnum WHERE a.attrelid = 'def'::regclass AND a.attname = 'f1'); id | f1 ----+----- 2 | foo 3 | foo (2 rows) 8<-------------------- Hope this helps, Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
