SELECT path, filename, bsd_flags FROM FILE WHERE path = '/tmp/file'; +-----------+----------+--------------+ | path   | filename | bsd_flags  | +-----------+----------+--------------+ | /tmp/file | file   | SF_IMMUTABLE | +-----------+----------+--------------+