Re: Perl query error

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
Cc: Patrick Hatcher <PHatcher(at)macys(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Perl query error
Date: 2002-04-11 13:55:12
Message-ID: Pine.BSO.4.40.0204110852080.12760-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Actually, one of the main things to keep in mind is that all those slash
commands are only supported by the psql frontend. If you examine
src/backend/parser/gram.y you won't find any of them in there. That means
you don't get to use them when using the DBI interface in perl since that
uses the standard backend interface. Just use that SQL reference in the
docs as a guide for what is allowed (and not).

That said, the -E flag is nice to see how core PostgreSQL developers have
implemented some queries. ;-)

Joshua b. Jore
http://www.greentechnologist.org

On 11 Apr 2002, Andrew McMillan wrote:

> On Thu, 2002-04-11 at 05:19, Patrick Hatcher wrote:
> >
> > Thanks for the help Josh.
> > Way too newbie to know what can or can't be done with DBI.
>
> :-)
>
> Use 'psql -E database' to see what the backend SQL is for the commands
> psql implements. Or you could use the source...
>
> Regards,
> Andrew.
> --
> --------------------------------------------------------------------
> Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
> WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
> DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
> Are you enrolled at http://schoolreunions.co.nz/ yet?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8tZXCfexLsowstzcRAvcBAJ4tf4R4lC3w+Ya0M+trj88Hw2RsSgCdEUUZ
g0/cTkPnjCg6aS5fZwv924Y=
=Ni33
-----END PGP SIGNATURE-----

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2002-04-11 16:58:10 Which encoding should I use?
Previous Message P. Jourdan 2002-04-11 12:32:51 migration problem