Re: [SQL] show index from [table]

2007-06-10 Thread Kristo Kaiv
On 08.06.2007, at 18:25, Stefan Zweig wrote: but actually i would need the information from within a (postgres) sql-query. is there a possibility to get information about the indices which have been created on a table? if there is not, it might be sufficient for me to get the create ind

Re: [SQL] show index from [table]

2007-06-08 Thread Ireneusz Pluta
Andreas Kretschmer napisaƂ(a): Yes, right. but actually i would need the information from within a (postgres) sql-query. is there a possibility to get information about the indices which have been created on a table? Yes, of corse. Please start psql with the -E - option. Now you can

Re: [SQL] show index from [table]

2007-06-08 Thread Andreas Kretschmer
Stefan Zweig <[EMAIL PROTECTED]> schrieb: > hi list, > > currently i am switching from mysql to pgsql, so i am a bit new to > postgres' syntax. You are welcome. > > at the moment i am looking in postgres for something which is similar > to SHOW INDEX FROM [table] in mysql. unfortunately i coul

[SQL] show index from [table]

2007-06-08 Thread Stefan Zweig
hi list, currently i am switching from mysql to pgsql, so i am a bit new to postgres' syntax. at the moment i am looking in postgres for something which is similar to SHOW INDEX FROM [table] in mysql. unfortunately i could not find anything satisfying relating to this issue. i have found out