login
psql dex_db
check available database \l
dex_db=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
d2 | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/dudu +
| | | | | dudu=CTc/dudu +
| | | | | dex=CTc/dudu
dex_db | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/dudu +
| | | | | dudu=CTc/dudu +
| | | | | dex=CTc/dudu
dexdb1 | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/dudu +
| | | | | dudu=CTc/dudu
template1 | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/dudu +
| | | | | dudu=CTc/dudu
(6 rows)
select db
\l dex_db
dex_db=# \l dex_db
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------+-------+----------+-------------+-------------+-------------------
dex_db | dudu | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/dudu +
| | | | | dudu=CTc/dudu +
| | | | | dex=CTc/dudu
(1 row)
list tables
\d
dex_db=# \d
List of relations
Schema | Name | Type | Owner
--------+-------------------------+----------+-------
public | authd_user | table | dex
public | client_identity | table | dex
public | connector_config | table | dex
public | dex_migrations | table | dex
public | key | table | dex
public | password_info | table | dex
public | refresh_token | table | dex
public | refresh_token_id_seq | sequence | dex
public | remote_identity_mapping | table | dex
public | session | table | dex
public | session_key | table | dex
(11 rows)
use encode
to show bytea type
dex_db=# select id,encode(secret,'escape') from client_identity;
-[ RECORD 1 ]--------------------------------------------------------
id | qWXRp93pWJ6mKzoYPlOEL9kgD8_QYQhCODaSEMbb2EE=@127.0.0.1
encode | $2a$10$a.NImDoBxch/GPO2XL/tH.Hc0wZEehZQXXPZstSb0ZNa8UDYWaK4u
describe table
dex_db=# \d session
Table "public.session"
Column | Type | Modifiers
--------------+---------+-----------
id | text | not null
state | text |
created_at | bigint |
expires_at | bigint |
client_id | text |
client_state | text |
redirect_url | text |
identity | text |
connector_id | text |
user_id | text |
register | boolean |
nonce | text |
scope | text |
Indexes:
"session_pkey" PRIMARY KEY, btree (id)
select table \x on
dex_db=# \x on
Expanded display is on.
dex_db=# select * from session;
-[ RECORD 1 ]+----------------------------------------------------------------------------------------------------------
id | YqEuCHscVgs=
state | REMOTE_ATTACHED
created_at | 1455864780
expires_at | 1455907980
client_id | qWXRp93pWJ6mKzoYPlOEL9kgD8_QYQhCODaSEMbb2EE=@127.0.0.1
client_state |
redirect_url | http://127.0.0.1:5555/callback
identity | {"ID":"115162047548008935474","Name":"","Email":"iamwhoami@gmail.com","ExpiresAt":"2016-02-19T07:53:41Z"}
connector_id | google
user_id |
register | f
nonce |
scope | openid email profile
-[ RECORD 2 ]+----------------------------------------------------------------------------------------------------------
id | 2prwA7hETTk=
state | EXCHANGED
created_at | 1455864909
expires_at | 1455908109
client_id | qWXRp93pWJ6mKzoYPlOEL9kgD8_QYQhCODaSEMbb2EE=@127.0.0.1
client_state |
redirect_url | http://127.0.0.1:5555/callback
identity | {"ID":"115162047548008935474","Name":"","Email":"iamwhoami@gmail.com","ExpiresAt":"2016-02-19T07:55:26Z"}
connector_id | google
user_id | 0ee2468c-5e74-426f-ba01-c555d7630a38
register | t
nonce |
scope | openid email profile
drop db
DROP DATABASE mydb;
drop table
DROP TABLE mytable;