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