How to recognize PG SQL files?
От | Joel Burton |
---|---|
Тема | How to recognize PG SQL files? |
Дата | |
Msg-id | 1060188951.2012.10.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: How to recognize PG SQL files?
Re: How to recognize PG SQL files? {REPOST, CLARIFIED} How to recognize PG SQL files? |
Список | pgsql-general |
I'm writing a syntax mode for PG for Vim (posted an early version earlier today) and would like to have Vim recognize that this is a PG SQL file (rather than a MySQL file or an Oracle file or such). I'm trying to brainstorm what the unique-looking parts of PG's syntax are. These need to be present in PG SQL files (& hopefully not too obscure) but not present in other DB SQL files. The PG manual states how PG differs from SQL standards, but not how it differs from other popular databases. I've used MySQL and Oracle in the past, but not recently, and haven't use DB2 or SQLServer in ages and don't have docs for them anymore. I have a few possible suggestions. Can anyone: * tell me if these are used in other DB systems (& shouldn't be part of my syntax) or * provide other ideas for unique PG syntax My ideas: * \connect * template1 * "from pg_" (selecting from a PG system table) * "create rule" * plpgsql, plperl, plpython, pltcl, pltclu, plruby (& now plphp, too, I suppose! ;) ) * "nextval(", "currval(" I'd love to find something common, like "SERIAL" or "CREATE SEQUENCE" or such, but I suspect that other commonly-used databases use these. Thanks for any help!
В списке pgsql-general по дате отправления: