is-valid-postgres-column-name 0.0.2

Allows you to check if a given string can be PostgreSQL column name

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("column_A", version=7.1)
>>> True

Installation

$ pip install -U is_valid_postgres_column_name

Requirements

Python 3.0+

Dependencies

None.

Contribution

Welcome.