Skip to content

Instantly share code, notes, and snippets.

@oldarmyc

oldarmyc/gist:67bb93f1832597fd8ed8fb40ecf93361

Created November 2, 2018 16:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oldarmyc/67bb93f1832597fd8ed8fb40ecf93361 to your computer and use it in GitHub Desktop.
Save oldarmyc/67bb93f1832597fd8ed8fb40ecf93361 to your computer and use it in GitHub Desktop.
Download ZIP
Getting all users in keycloak
Raw
gistfile1.txt
kubectl get pods . # Get the postgres pod
kubectl exec -it anaconda-enterprise-postgres-68b49746ff-fv7qk /bin/bash
su - postgres
psql
\c anaconda_auth
select email, enabled, first_name, last_name, username from user_entity;
All table headings incase you want to change the select.
id, emai, email_constraint, email_verified, enabled, federation_link, first_name, last_name, realm_id, username, created_timestamp, service_account_client_link, not_before
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment