这是indexloc提供的服务,不要输入任何密码
Skip to content

SQL Syntax Highlighting Issue for INT and VARCHAR on macOS #8235

@Piotr2804

Description

@Piotr2804

I am experiencing an issue with SQL syntax highlighting in pgAdmin 4 on macOS. While writing SQL queries in the Query Tool, most keywords are highlighted as expected. However, the data types INT and VARCHAR are not highlighted in purple (or the expected color for keywords), unlike other SQL keywords.

Steps to explain how it happen:
1- Open pgAdmin 4 on macOS.
2- Go to the Query Tool and write a simple SQL query, such as:
CREATE TABLE test_table (
id INT,
name VARCHAR(50)
);

3- Observe that the keywords INT and VARCHAR are not highlighted, whereas other keywords (e.g., CREATE, TABLE) are highlighted correctly.

Environment:
pgAdmin 4 Version: 8.13
Operating System: macOS Sonoma 14.2.1
Theme/Preferences: Default theme, no custom syntax highlighting applied.

I have already tried several troubleshooting steps to resolve the issue, including:

  • Resetting all settings in pgAdmin 4.
  • Uninstalling and reinstalling both PostgreSQL and pgAdmin 4.
  • Switching between different syntax highlighting themes in the Query Tool preferences.

Unfortunately, none of these actions have resolved the issue, and the keywords INT and VARCHAR still do not appear highlighted as expected.
Please let me know if any additional details or logs are required. Thank you for your assistance!

IMG_5096
IMG_5095

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions