Re: SQL quote sign syntax fail

On So, 12 Mär 2023, Hans Schou wrote:

> Hi
>
> I have a PostgreSQL dump file with some data in a COPY..stdin block.
> When an quote sign occur in "O'Malley" the color changes until next quote sign
>
> Example in file names.sql:
>
> COPY public.names (name) FROM stdin;
> Thomas O'Malley
> \.
>
> The quote is a legal character in that block and the color should not be
> changed.
>
> After \. on a single line the color should go back to normal.
>
> Any hint is much appreciated.

Vim supports several different SQL dialects out-of-the box, but it looks
like PostgreSQL is not available by default (and it assumes that if no
dialect is specified, it will try to use Oracle SQL).

The above looks invalid to my eye for Oracle (but it's been a awhile
since I used Oracle SQL intensively), so I wouldn't expect this to work
properly. So perhaps looks for specific PostgreSQL syntax file.

The already mentioned pgsql from lifepillar seems to be specific for
PostgreSQL (even so it seems to have the same issue as mentioned
elsewhere).

See also :h ft_sql.txt and :h sql.vim

Best,
Christian
--
Frage an Radio Eriwan:
Wir wollen in unserer Schule Schillers Wilhelm Tell aufführen. Dürfen wir das?
Radio Eriwan antwortet:
Im Prinzip ja - aber woher wollt ihr den Apfel nehmen?

--
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

---
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/vim_use/ZA8vvUlrKK1T2vLg%40256bit.org.