Perl query error

[Andrew McMillan]

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 majo...@postgresql.org

[Joshua b. Jore]

-----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

-----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-----

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majo...@postgresql.org)