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
Osvaldo,
Thanks! This is a great solution. It definitely is very easy to read. I like
to have my SQL as clean as my java code. I ended up using the following:
SELECT some_timestamp FROM some_table WHERE some_timestamp::date >
'yesterday'::date;
Thanks,
Lance Campbell
Project Manager/Softwa
