Format document fails when using psql variables in SQL

TeamSQL / desktop-app

This repository is currently being used for hosting the official issue & bug tracker of TeamSQL Desktop App.

102 stars 6 forks source link

Format document fails when using psql variables in SQL #427

Open mgrabenstein opened 5 years ago

mgrabenstein commented 5 years ago

OS: Darwin x64 17.7.0 VERSION: 4.0.379

Database Type: Redshift / Postgres

This SQL: drop table if exists :psql_var_report_table; create table :psql_var_report_table ( id int, name varchar(255) );

Will not format via format document. Since the SQL document I have is run by psql, I always have a lot of variables in the SQL that psql will replace before execution.

ghost commented 5 years ago

Hi @mgrabenstein, thanks for reaching out. We'll investigate this issue and get back to you with a solution as soon as possible. Please stay tuned!

mgrabenstein commented 5 years ago

Thanks