On Thursday 27 April 2006 07:43 pm, Devrim GUNDUZ <devrim@xxxxxxxxxxxxxxxxx> 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)