Thread: .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 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