Re: [HACKERS] listing triggers

2004-08-19 Thread Erwin Moller
eated implicitly and explicitly. Robert Treat explained also that the reason that I don't see them has to do with the fact that the triggers were created implicitly (dervied from references syntax in create table, or alter table add foreign key syntax). Thanks for your help/explanation. (Robert

Re: [HACKERS] listing triggers

2004-08-08 Thread Erwin Moller
says: \d [NAME] describe table, index, sequence, or view \d{t|i|s|v|S} [PATTERN] (add "+" for more detail) list tables/indexes/sequences/views/system tables No triggers So, I am still in the dark. Regards, Erwin Moller ---(end of broad

[HACKERS] listing triggers

2004-08-06 Thread Erwin Moller
Hi, When using psql I can list the tables and sequences by typing: \d futhermore: \dt lists tables \ds lists sequences \d tablename lists that table. etc. etc. But how can I get a listing of all used triggers on a certain table? Thanks for your time Regards, Erwin Moller

Re: [HACKERS] Enter the #1 Hacker site on the entire internet!

2004-08-06 Thread Erwin Moller
ApocalypseKnight wrote: > > Learn how to Hack into computers,websites,Aol/Yahoo/Msn accounts,view > webcams without permission,computer programming,and much,MUCH more at: > > http://stop.to/Hacker > > and: > > http://groups.msn.com/SecretsoftheCyberWarrior > > ApocalypseKnight I think Apocal

[HACKERS] Is this possible? concatenating results from a subquery

2004-04-26 Thread Erwin Moller
concat word I use is pure fantasy. Is this at all possible? I know I can easily circumvent te problem by my scriptinglanguage (PHP), but that will result in many extra queries. How do I proceed? TIA!! Regards, Erwin Moller ---(end of broadcast

Re: [HACKERS] Is this possible? concatenating results from a subquery

2004-04-26 Thread Erwin Moller
Thanks Janko! I was hoping for a query-only solution (SQL only), but this will work just great. :-) If I switch database this code will give me some trouble. I guess I'll have to stick to Postgresql. ;-) Thanks. Regards, Erwin Moller Janko Richter wrote: > Perhaps this helps: >