dbeaver - ghdrako/doc_snipets GitHub Wiki

dbeaver

Click on Tables -> Views Tables -> Select All tables in right window Right click selection -> Generate SQL" -> DDL

Filter - add table to filter

Right Click on Connection -> Tools --> Session Manager/Lock Manager

Right Click on Connection -> Edit Connection --> Zakladka PostgrSQL --> checkbox Show all databases

Extract password

• https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection

# windows
openssl aes-128-cbc -d -K babb4a9f774ab853c96c2d653dfe544a -iv 00000000000000000000000000000000 -in "%AppData%\DBeaverData\workspace6\General\.dbeaver\credentials-config.json"
# mac
openssl aes-128-cbc -d -K babb4a9f774ab853c96c2d653dfe544a -iv 00000000000000000000000000000000 -in ~/Library/DBeaverData/workspace6/General/.dbeaver/credentials-config.json

openssl aes-128-cbc -d \
  -K babb4a9f774ab853c96c2d653dfe544a \
  -iv 00000000000000000000000000000000 \
  -in credentials-config.json | \
  dd bs=1 skip=16 2>/dev/null