known_hosts

A line-delimited known_hosts table.

Table schema

Name Type Description
uid BIGINT The local user that owns the known_hosts file
key TEXT parsed authorized keys line
key_file TEXT Path to known_hosts file

Query examples

select * from users join known_hosts using (uid)