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';