--- Benutzerübersicht gewinnen (LoginID, Name, Int. Durchwahl)
COPY
    (SELECT l.login as loginid,
        a.comment as name,
        n.extention as durchwahl,
        t.name as type
    FROM accountlogin as l, account as a, telephonenumber as n, accounttype as t
    WHERE l.accountid = a.id
        AND a.primarytelephonenumberid = n.id
        AND a.accounttypeid = t.id
        --- Keine Gruppen:
        --- AND a.accounttypeid != 5
    ORDER BY n.extention::int ASC)
TO '/tmp/test.csv' WITH CSV;