Hi,
I am dealing with an already built database from which there is no
documentation available on how it was designed. I can list indices, tables,
and sequences from the DB using the '\d' command. But how can I list
functions, triggers, and other implementations?
Thank in advance for your reply.
Hi,
I work in an environment where people can update
the PostgreSQL database from several sites (insert, update, delete
statements).
If two people try to update, insert or delete
the same row at the same time, or if one deletes a row
that the other is viewing and trying to update, in post
Hello all,
as usual in CS, there can be many ways to do the same thing.
For instance, I can uppercase a string in a function in POstgreSQL or I can
uppercase it before sending the query to the database. I am reading Bruce
Monjian's book right now (page 204, Functions & triggers/triggers), and I a