On Sun, Dec 28, 2003 at 04:29:56AM -0500, Casey Allen Shobe wrote:
> Martijn van Oosterhout (Sunday 28 December 2003 02:57)
> > Yes, they do vary, there is no stardard. As you point out, DB2 and MySQL
> > use different commands, as does probably every other database. There is no
> > command that is going to work everywhere.
>
> That's not what I meant. I mean that they *only* work in the psql client, not
> when using PostgreSQL via ODBC or another interface.
Hmm, I see. Obviously you could use the -E option to get the queries but it's
not the same I grant you. SQL now defines an INFORMATION_SCHEMA, maybe that
will bring some method to the madness.
> > psql has variables, though I can't comment on how they compare to MSSQL's.
>
> Do you happen to have a link to documentation? If these aren't new, then I've
> just somehow overlooked it. I'd love to read further...
Interesting, I found them in psql's manpage under ADVANCED FEATURES -
VARIABLES. Let's see if I can find it on the web... Here's a web version of
the manpage.
http://www.postgresql.org/docs/current/interactive/app-psql.html
They're not in the backend though, though I'm not sure why you'd want that.
Ofcourse, pl/pgsql has variables as do all the other languages.
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce