microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
199 stars 37 forks source link

Add Postgres Language Mode #178

Open damiensawyer opened 4 years ago

damiensawyer commented 4 years ago

I'm not sure if this is in the purview of this extension, however it would be great to have language mode support for PostgreSQL specific SQL syntax.

For example.

select * from mytable WHERE id= $$4754e16a-a7ca-4846-9967-b42043181ef9$$::uuid;

In the example above, PostgreSQL will treat the $$ signs as text delimiters (very addictive once you get the hang of it!!)

Currently the syntax highlighting will not respect the dollar signs.

Thanks :-)

stepaunov commented 4 years ago

Highlighting text between $$ as string can break function body and do-block code highlighting.