Skip to main content

ssh_public_keys

Creates, updates, deletes, gets or lists a ssh_public_keys resource.

Overview

Namessh_public_keys
TypeResource
Idgoogle.oslogin.ssh_public_keys

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringOutput only. The canonical resource name.
expirationTimeUsecstring (int64)An expiration time in microseconds since epoch.
fingerprintstringOutput only. The SHA-256 fingerprint of the SSH public key.
keystringRequired. Public key text in SSH format, defined by RFC4253 section 6.6.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectusersId, sshPublicKeysIdRetrieves an SSH public key.
createinsertusersIdCreate an SSH public key
patchupdateusersId, sshPublicKeysIdupdateMaskUpdates an SSH public key and returns the profile information. This method supports patch semantics.
deletedeleteusersId, sshPublicKeysIdDeletes an SSH public key.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
sshPublicKeysIdstring
usersIdstring
updateMaskstring (google-fieldmask)

SELECT examples

Retrieves an SSH public key.

SELECT
name,
expirationTimeUsec,
fingerprint,
key
FROM google.oslogin.ssh_public_keys
WHERE usersId = '{{ usersId }}' -- required
AND sshPublicKeysId = '{{ sshPublicKeysId }}' -- required
;

INSERT examples

Create an SSH public key

INSERT INTO google.oslogin.ssh_public_keys (
data__expirationTimeUsec,
data__key,
usersId
)
SELECT
'{{ expirationTimeUsec }}',
'{{ key }}',
'{{ usersId }}'
RETURNING
name,
expirationTimeUsec,
fingerprint,
key
;

UPDATE examples

Updates an SSH public key and returns the profile information. This method supports patch semantics.

UPDATE google.oslogin.ssh_public_keys
SET
data__expirationTimeUsec = '{{ expirationTimeUsec }}',
data__key = '{{ key }}'
WHERE
usersId = '{{ usersId }}' --required
AND sshPublicKeysId = '{{ sshPublicKeysId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
expirationTimeUsec,
fingerprint,
key;

DELETE examples

Deletes an SSH public key.

DELETE FROM google.oslogin.ssh_public_keys
WHERE usersId = '{{ usersId }}' --required
AND sshPublicKeysId = '{{ sshPublicKeysId }}' --required
;