I found it weird there's no simple way to check if a given string can be a PostgreSQL column name. Although, to my understanding, you can escape with quotation marks some names that are otherwise invalid, I don't think escaping such a thing is a good idea.

This validation is required if your column name can be dynamically generated.

How to use

>>> from is_valid_postgres_column_name import is_valid_postgres_column_name
>>> is_valid_postgres_column_name("column_A")
True
>>> is_valid_postgres_column_name("1column_A")
False

All PostgreSQL versions are supported. The only difference between versions, to my knowledge, are reserved keywords.

>>> is_valid_postgres_column_name("window", version=13)
False
>>> is_valid_postgres_column_name("window", version=7.1)
True

Installation

$ pip install -U is_valid_postgres_column_name

Requirements

Python 3.0+

Dependencies

None.

Contribution

Welcome.

Alternatives

If you don't want to download additional library for such a simple thing, have a look at sqlparse keywords.py file.