Re: Perl query error - Mailing list pgsql-novice

From Joshua b. Jore
Subject Re: Perl query error
Date
Msg-id Pine.BSO.4.40.0204110852080.12760-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Re: Perl query error  (Andrew McMillan <andrew@catalyst.net.nz>)
List 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@postgresql.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-----


pgsql-novice by date:

Previous
From: "P. Jourdan"
Date:
Subject: migration problem
Next
From: "Patrick Hatcher"
Date:
Subject: Which encoding should I use?