It's hard to distinguish column names of table

[hwooo]

Description

Title color of tables is white foreground with grey background so it's hard to distinguish. This issue occurs in mycli too.

Your environment

• [ ] Windows 10 18362.145
• [ ] 2.1.0
• [ ] What is the output of pip freeze command.

  aniso8601==6.0.0
  asn1crypto==0.24.0
  beautifulsoup4==4.7.1
  blinker==1.4
  bs4==0.0.1
  certifi==2019.3.9
  cffi==1.12.2
  chardet==3.0.4
  cli-helpers==1.2.0
  Click==7.0
  colorama==0.4.1
  configobj==5.0.6
  cryptography==2.6.1
  Django==2.2
  Flask==1.0.2
  Flask-Mail==0.9.1
  Flask-MySQL==1.4.0
  Flask-RESTful==0.3.7
  httpie==1.0.2
  humanize==0.5.1
  idna==2.8
  itsdangerous==1.1.0
  Jinja2==2.10.1
  MarkupSafe==1.1.1
  mycli==1.19.0
  pgcli==2.1.0
  pgspecial==1.11.5
  prompt-toolkit==2.0.9
  psycopg2==2.7.7
  pycparser==2.19
  Pygments==2.3.1
  PyJWT==1.7.1
  pymongo==3.8.0
  PyMySQL==0.9.3
  pytz==2018.9
  requests==2.21.0
  selenium==3.141.0
  setproctitle==1.1.10
  six==1.12.0
  soupsieve==1.9
  sqlparse==0.2.4
  tabulate==0.8.3
  terminaltables==3.1.0
  urllib3==1.24.1
  wcwidth==0.1.7
  Werkzeug==0.15.2

[j-bennet]

You can override table header style in your ~/.myclirc (or ~/.config/pgcli/config). See this line:

https://github.com/dbcli/mycli/blob/05a0e4ad9523d839c610574326030ad180acaafe/mycli/myclirc#L110

Try setting background color explicitly to override that grey, for example: bg:#000000 #ff0000 bold.

@jonathanslenders Where did that grey background color came from? It does not seem like it's a mycli default.

[dbaty]

This issue is old and has been reported against 2.1.0, which has been released 4 years ago. I cannot reproduce this issue with the latest version of pgcli (4.0.1): with a black background, column names appear in bold green (and I don't think I have customized anything). I'll suppose that this issue has been fixed, and am closing it.

[sryze]

I can reproduce this issue with pgcli 4.0.1 in cmd.exe or in PowerShell/Git Bash inside Wndows Terminal (with the One Half Dark theme).

It appears that my config is not the cause as the same happens if I delete it.

[j-bennet]

@sryze

If you deleted the pgcli's default config file, it would create a new one in the user directory. For Linux or Mac, this would be ~/.config/pgcli/config; for Windows, %USERPROFILE%\\AppData\\Local\\dbcli\\pgcli\\config.

For this header, the style is controlled by the output.header setting. On my system, with default settings, it looks like this:

However, when I set it as follows:

output.header = 'bg:#cccccc #ff0000 bold'

the look changes:

It appears that my config is not the cause as the same happens if I delete it.

Not necessarily. What you're seeing might be happening because the default pgcli config settings don't play well with your terminal colors. Try changing the style n the config and see if that changes anything. You'll have to exit and restart pgcli to pick up the change.