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

Column	Type	Nullable	Description
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

$ dsql -e 'SELECT * FROM deltastream.sys."pgusers";'
[{"organization_id":"00000000-0000-0000-0000-000000000001","name":"test","role_name":"sysadmin","username":"dspg_b6b2a6a36cb54e50a8a89c13c3527cf2","expires_at":null,"owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"[e-mail]","created_at":"2026-01-07T20:39:27.914Z","updated_by_role":null,"updated_by_role_deleted":null,"updated_by":null,"updated_at":"2026-01-07T20:39:27.914Z"}]

See Also

• System Tables Overview