Retrieve SSH Keys in DigitalOcean.
View Specific Information
Digital Ocean supports only Id and Fingerprint columns with "=" operator as filter criteria for this view.
SELECT * FROM SSHKeys WHERE Id=21810045 SELECT * FROM SSHKeys WHERE Fingerprint='71:ad:9f:e4:fb:8c:dc:89:e1:ac:8d:ee:73:7a:fa:ae'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
|Id [KEY]||Integer||This is a unique identification number for the key. This can be used to reference a specific SSH key when you wish to embed a key into a Droplet.|
|Name||String||This is the human-readable display name for the given SSH key. This is used to easily identify the SSH keys when they are displayed.|
|Fingerprint [KEY]||String||This attribute contains the fingerprint value that is generated from the public key. This is a unique identifier that will differentiate it from other keys using a format that SSH recognizes.|
|PublicKey||String||This attribute contains the entire public key string that was uploaded. This is what is embedded into the root user's authorized_keys file if you choose to include this SSH key during Droplet creation.|