.psqlrc and custom functions (mysql-like)
hi,
As part of a product we are building, we are using postgres as our
database. But most of our developers have a (loud) mysql background.
I want to potentially provide "aliases" for a few commonly used mysql
functions.
I see that the .psqlrc could potentially be the place where you could
define these custom functions - I looked at
http://okbob.blogspot.com/2009/12/macros-for-epsql.html but it seems to be a
patched psql. Is is possible to have the exact same commands as defined in
that page in a .psqlrc .. via plpgsql or something ?
I might be totally way off the target here, so please correct me if I am
wrong.
As an example, how would I do something as simple as "DESCRIBE table" (yes I
know \d+ equivalent.. I still want to be able to define this function)
thanks and regards
Sandeep
Hello
2010/8/14 Sandeep Srinivasa <sss@clearsenses.com>:
hi,
As part of a product we are building, we are using postgres as our
database. But most of our developers have a (loud) mysql background.
I want to potentially provide "aliases" for a few commonly used mysql
functions.
I see that the .psqlrc could potentially be the place where you could
define these custom functions - I looked at
http://okbob.blogspot.com/2009/12/macros-for-epsql.html but it seems to be a
patched psql. Is is possible to have the exact same commands as defined in
that page in a .psqlrc .. via plpgsql or something ?
no, and it will not be a possible in near future.
I might be totally way off the target here, so please correct me if I am
wrong.
As an example, how would I do something as simple as "DESCRIBE table" (yes I
know \d+ equivalent.. I still want to be able to define this function)
thanks and regards
Sandeep
Regards
Pavel Stehule