I'm getting the following ERROR: column p.proisagg does not exist

[zhanyl91]

I'm trying to generate a documentation for PostgreSQL database version both 11, 12
I'm using this command java -jar ~/schemaspy.jar -t pgsql -dp ~/jdbc-driver.jar -db DATABASE -host SERVER -port 1433 -s dbo -u USER -p PASSWORD -o DIRECTORY running on Mac

Expected Behavior

Current Behavior

Possible Solution

Steps to Reproduce (for bugs)

Context

• Database type (e.g. MySQL):
• Database driver version (is you use a special one):
• Your DDL (sample how to reproduce the issue):
• Full command including arguments how you run SchemaSpy:

Your Environment

• Version used:
• Environment name and version (e.g. Chrome 39):
• Operating System and version (e.g. Windows 10):
• Java version:

[npetzall]

There are a couple of open issues regarding this. It was solved by introducing a new databaseType for pgsql 11 and newer.

Switch -t pgsql to -t pgsql11

Should work as long as you have a fairly recent version of SchemaSpy.