Re: [GENERAL] Read an already existing DB: functions & triggers.

2000-06-18 Thread T.J.Farrell
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.

[GENERAL] PostgreSQL and multiple database access

2000-06-13 Thread T.J.Farrell
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

[GENERAL] Postgresql and programming

2000-06-13 Thread T.J.Farrell
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