For vim users: Syntax highlighting for PostgreSQL

Hi,

I just wrote a pgsql.vim file for vim users. It helps you to colorize
the file which contains PostgreSQL SQL keywords:

http://www.gunduz.org/postgresql/pgsql.vim

In order to use this file, first edit filetype.vim file and add

" PgSQL
au BufNewFile,BufRead *.pgsql setf pgsql

to the relevant part. We will need to do this until this file becomes an
official part of vim.

Then put pgsql.vim to the syntax directory of vim
(/usr/share/vim/vim64/syntax on my Fedora Core 5). After you rename your
sql file as filename.pgsql, the syntax highlighting will be enabled.

What I've added so far:

- All the functions
- All the data types
- Many of the keywords (let us see if I've missed anything)
- Comments

I've used mysql.vim as a template. Thanks to \df, \dT and psql's -E for
making this process easier. :)

If you are vim user, please test it and send the possible
errors/additions to me. I intend to send this file to vim developers,
too, after the testing.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/

On Thursday 27 April 2006 07:43 pm, Devrim GUNDUZ <devrim(at)commandprompt(dot)com>
thus communicated:
--> Hi,
-->
--> I just wrote a pgsql.vim file for vim users. It helps you to colorize
--> the file which contains PostgreSQL SQL keywords:
-->
--> http://www.gunduz.org/postgresql/pgsql.vim
-->
--> In order to use this file, first edit filetype.vim file and add
-->
--> " PgSQL
--> au BufNewFile,BufRead *.pgsql setf pgsql
-->
--> to the relevant part. We will need to do this until this file becomes an
--> official part of vim.
-->
--> Then put pgsql.vim to the syntax directory of vim
--> (/usr/share/vim/vim64/syntax on my Fedora Core 5). After you rename your
--> sql file as filename.pgsql, the syntax highlighting will be enabled.
-->
--> What I've added so far:
-->
--> - All the functions
--> - All the data types
--> - Many of the keywords (let us see if I've missed anything)
--> - Comments
-->
--> I've used mysql.vim as a template. Thanks to \df, \dT and psql's -E for
--> making this process easier. :)
-->
--> If you are vim user, please test it and send the possible
--> errors/additions to me. I intend to send this file to vim developers,
--> too, after the testing.
-->
--> Regards,
--> --
--> The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
--> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--> Managed Services, Shared and Dedicated Hosting
--> Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
-->
-->
--> ---------------------------(end of broadcast)---------------------------
--> TIP 6: explain analyze is your friend
-->
Thanks! I'll check this out ;o)

Devrim GUNDUZ wrote:
> Hi,
>
> I just wrote a pgsql.vim file for vim users. It helps you to colorize
> the file which contains PostgreSQL SQL keywords:
(...)

> - Many of the keywords (let us see if I've missed anything)
> - Comments
>
> I've used mysql.vim as a template. Thanks to \df, \dT and psql's -E for
> making this process easier. :)
>
> If you are vim user, please test it and send the possible
> errors/additions to me. I intend to send this file to vim developers,
> too, after the testing.

Thank you! I find this useful and am testing it.
Should feedback go to this thread in the newsgroup or to your email
account or another channel?

Regards
Erwin

Hi,

On Mon, 2006-05-01 at 15:15 -0700, brsaweda(at)gmail(dot)com wrote:

> Thank you! I find this useful and am testing it.

Great to hear that. I'm also working on plpgsql.vim file.

> Should feedback go to this thread in the newsgroup or to your email
> account or another channel?

I think e-mail to me is fine.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

+----[ Devrim GUNDUZ <devrim(at)commandprompt(dot)com> (27.Apr.2006 23:39):
|
| Hi,
|
| I just wrote a pgsql.vim file for vim users. It helps you to colorize
| the file which contains PostgreSQL SQL keywords:
|
| http://www.gunduz.org/postgresql/pgsql.vim

Devrim,

thanks for contributing this!

| In order to use this file, first edit filetype.vim file and add
|
| " PgSQL
| au BufNewFile,BufRead *.pgsql setf pgsql
|
| to the relevant part. We will need to do this until this file becomes an
| official part of vim.

This is not necessary. You can add it to your ~/.vimrc and
it will work. If you want to set this system wide you can
include the above command inthe system wide vimrc (in my
FreeBSD box this is /usr/local/share/vim/vimrc)

| Then put pgsql.vim to the syntax directory of vim
| (/usr/share/vim/vim64/syntax on my Fedora Core 5). After you rename your
| sql file as filename.pgsql, the syntax highlighting will be enabled.
|
+----]

Again, you can also put it in ~/.vim/syntax/ and it will
work.

Just wanted to add that without have root access anyone
can still benefit from your work!

Thanks again!

Fernan