pgusers
Description
Exposes metadata about pguser credentials in the organization. Pgusers are PostgreSQL-compatible credentials that allow direct database access using standard PostgreSQL drivers. The credential password is never exposed. Only pgusers on which the current role has USAGE privileges are returned.
Note Pguser passwords are never returned by this table. Only the username and metadata are accessible.
Syntax
SELECT * FROM deltastream.sys."pgusers";Columns
organization_id
VARCHAR
No
The unique identifier of the organization this resource belongs to.
name
VARCHAR
No
User-defined name for the pguser credential.
role_name
VARCHAR
No
The DeltaStream role associated with this pguser.
username
VARCHAR
No
The PostgreSQL-compatible username generated for this credential (e.g. dspg_<hash>).
expires_at
TIMESTAMP_LTZ
Yes
Expiry timestamp for the credential, or null if it does not expire.
owner
VARCHAR
No
The role that owns this resource.
created_by_role
VARCHAR
No
The role that created this resource.
created_by_role_deleted
BOOLEAN
No
Whether the creating role has since been deleted.
created_by
VARCHAR
No
The user that created this resource.
created_at
TIMESTAMP_LTZ
No
Timestamp when this resource was created.
updated_by_role
VARCHAR
Yes
The role that last updated this resource.
updated_by_role_deleted
BOOLEAN
Yes
Whether the last updating role has since been deleted.
updated_by
VARCHAR
Yes
The user that last updated this resource.
updated_at
TIMESTAMP_LTZ
No
Timestamp when this resource was last updated.
Examples
See Also
Last updated