During an accessibility review of Citus it was found that psql has some accessibility issues.
Postgres version: 12.3
OS: Windows 10
Running this simple query has some issues:
SELECT * FROM (VALUES (1, 'microsoft', 'microsoft.png', now(), now()), (2, 'azure', 'azure.png', now(), now())) as t(id, name, image, created, modified);
- The table that is shown is not detected as a table by the screen reader. So, a screen reader user cannot navigate the table in a user-friendly way.
- Datetimes are not being read by the screen reader as datetimes. So instead of saying "9th of March 2020, 10 hours 28 minutes and 46 seconds" it will instead say "2020 dash zero three dash zero nine 10 colon 28 colon 46"
- After using 400% zoom the whole table doesn't fit in the window anymore and it starts to wrap in ugly ways. Instead it should resize the cells. You can easily reproduce this by making the standard psql window a bit smaller and you will see the same effect.
The screen reader that was used is the "Narrator" that is included in windows.
I'm not sure if this is can be fixed easily. Since all these issues seem to stem from the fact that it's a text only interface. So, it would probably require instrumenting this text in some way with accessibility attributes.
Jelte