[GENERAL] database information

2001-07-30 Thread Peter Choe
how do i get the names of the databases that are created in postgres? is there a select statement similar to oracle? peter choe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] changing partial data

2001-07-11 Thread Peter Choe
the word test to exam, can i just replace the word test rather than reentrying to who value of the column? so, instead of: update foo set description='this is a exam' where description='this is a test'; can i do something like: update foo replace test wi

[GENERAL] error starting postmaster

2001-06-08 Thread Peter Choe
i just installed postgresql7.1 on a freebsd 4.3-stable machine. and i am able to start it with: postmaster -D data but when i try to: createdb test i get the following error: /usr/libexec/ld-elf.so.1: Shared object "libpq.so.2" not found where can i get libpq.so.2?

[GENERAL] creating a trigger to write to a different table

2001-03-22 Thread Peter Choe
column in the status table to reflect the change. in the documents, i just see triggers used on one table. peter choe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] how to create a simple trigger

2001-03-14 Thread Peter Choe
do i pass a parameter from the trigger to the function? peter choe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl