Re: How to recognize PG SQL files?

From: perltastic <perltastic(at)yahoo(dot)com>
To: Joel Burton <joel(at)joelburton(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to recognize PG SQL files?
Date: 2003-08-11 17:22:43
Message-ID: 20030811172243.87892.qmail@web21601.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks very much for taking this task up. Can you pl. mention where did you
upload the version of the syntax file that you are talking about ? Is it on the
www.vim.org site or www.postgresql.org. I tried looking into the vim.org
repository but could not find one.

Thanks, in advance.

Bhavesh

--- Joel Burton <joel(at)joelburton(dot)com> wrote:
> 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!
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Benoit 2003-08-11 17:28:19 Re: Tsearch limitations
Previous Message Weiping He 2003-08-11 17:12:27 Re: locale and encoding