search

fjenett / sql-library-processing

SQLibrary – a SQL database library for Processing incl. MySQL, SQLite and PostgreSQL
http://fjenett.github.com/sql-library-processing/
37 stars 24 forks source link

Remove quotes from table_name. #17

Closed erictheise closed 1 year ago

erictheise commented 6 years ago

I'm seeing this error when trying to connect a Processing 3.3.7 sketch to my local PostgreSQL database

postgres=# ERROR:  syntax error at or near "'table_name'" at character 19
STATEMENT:  SELECT relname AS 'table_name' FROM pg_stat_user_tables WHERE schemaname='public'

and it's the same one discussed in this forum thread from 2015.

I don't know my way around the Processing ecosystem and am a little confused about whether this is the active repository (the latest release here seems to be 0.2.0 but whatever's in my Contribution Manager reports itself as 0.3).

Any feedback appreciated, hard to believe I'm the only PostgreSQL/Processing user.