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 <[EMAIL PROTECTED]> 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
pgp00000.pgp
Description: PGP signature
