CREATE TABLE user_extra( id BIGSERIAL PRIMARY KEY, sex VARCHAR(10), province VARCHAR(100), city VARCHAR(100), country VARCHAR(100), has_subscribed BOOLEAN, subscribe_time TIMESTAMP ); Then run this ...
My table has a function for a computed column called status. To query the computed column you have to reference the table name or alias, ie. select colA, colB, status from mytable -- this will fail ...