sohosting=# \d sogo_auth 
    View "public.sogo_auth"
   Column   | Type | Modifiers 
------------+------+-----------
 c_uid      | text | 
 c_name     | text | 
 c_password | text | 
 c_cn       | text | 
 mail       | text | 
View definition:
 SELECT (b.username || '@'::text) || b.fk_domain AS c_uid, (b.username || '@'::text) || b.fk_domain AS c_name, b.passwd AS c_password, b.description AS c_cn, (b.username || '@'::text) || b.fk_domain AS mail
   FROM mailbox b, maildomain d
  WHERE b.fk_domain = d.name AND d.enabled AND b.enabled AND d.sogo_allowed;

sohosting=#