Re: [GENERAL] .psqlrc and custom functions (mysql-like)

2010-08-15 Thread Pavel Stehule
Hello

2010/8/14 Sandeep Srinivasa :
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] .psqlrc and custom functions (mysql-like)

2010-08-14 Thread Sandeep Srinivasa
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