.Dd March 22, 2013
.Os SQLite\ UDF
.Dt STRMODE \&3s "SQLite User-defined Functions"
.Sh NAME
.Nm strmode
.Nd Extract inode metadata for a filename
.Sh LIBRARY
SQLite User-defined function Library (readdir.so)
.Sh SYNOPSIS
select
.Pf strmode( Pa mode Ns );
.Sh DESCRIPTION
The 
.Nm
function executes a call to 
.Xr strmode 3
for 
.Pa mode
returning a permission string as would be shown by long form of
.Xr ls 1 .
.Sh EXAMPLES
.Bd -literal
sqlite> select strmode(stat('/home', 'mode')) as mode;
mode       
-----------
drwxr-xr-x 
.Ed
.Sh IMPLEMENTATION NOTES
To use 
.Nm
in the SQLite shell
.Ic sqlite3 ,
add the following to your 
.Pa ${HOME}/.sqliterc 
file:
.sp
.Dl .load /usr/local/lib/sqlite3/readdir.so
.Sh SEE ALSO
.Xr readdir 3s
.Xr stat 3s
.Pp
The above SQLite user-defined functions are intended for use with 
.Nm .
.Sh AUTHORS
.Nm
was contributed by James K. Lowden
.\" .Sh BUGS