Re: [SQL] Triggers

Hi, Plesae read my previous message in this mail list, on 2006-08-15. 14.20 at " [SQL] Undo an update" thread. bye, kjt McAfee SCM 4.1 által ellenőrizve! ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriat

Re: [SQL] Undo an update

2006. August 11. Friday 19.26 dátummal Judith ezt írta: > > Is there a way to undo an update??? > At the 1st time: I speak little english, so I sorry. If I understand, what's your problem, maybe I can help you... Maybe... So, if I'd like to save the inserted, deleted and/or updated rows, then

[SQL] usernames of a group from SQL

Hi, At the first time: I'm in newbie in SQL... I'm sorry! My question is: How can I get the usernames of a group (for example 'osztatlan_users') from SQL? I try it: SELECT usename FROM pg_user WHERE usesysid IN (SELECT grolist FROM pg_group WHERE groname='osztatlan_users') ORDER BY pg_user;

Re: [SQL] Database OID

2006. May 17. Wednesday 09.51 dátummal Achilleus Mantzios ezt írta: > > > > How can I find the database OID from simple SQL command? > > SELECT oid,* from pg_database ; > I'm stupid! Thanks, kjt McAfee SCM 4.1 által ellenőrizve! ---(end of broadcast)

[SQL] Database OID

Hi, How can I find the database OID from simple SQL command? Thanks, kjt McAfee SCM 4.1 által ellenőrizve! ---(end of broadcast)--- TIP 6: explain analyze is your friend