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 see
the underlying sql-statement for commands like \di.
... or even better:
select * from pg_indexes where tablename = 'your_table';
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
