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