pointers or point me to the docs?
Thanks,
Craig Boyd
Tom Lane wrote:
"Boyd, Craig" writes:
I am trying to pull together some general information about indices
(indexes?) for a particular table.
I need the following: Index Name, Table Name, Column Name,
Unique/Non-Unique, a
Hello All,
I am trying to pull together some general information about indices
(indexes?) for a particular table.
I need the following: Index Name, Table Name, Column Name,
Unique/Non-Unique, and ordinal position in the index.
The information_schema.key_column_usage gets me most of the way ther
Look here:
http://sqlmanager.net/en/products/postgresql
They aren't cheap, but they seem to work well.
Thanks,
Craig Boyd
David Kerr wrote:
On Fri, Aug 21, 2009 at 12:00:11PM -0700, Joshua D. Drake wrote:
- On Fri, 2009-08-21 at 11:56 -0700, David Kerr wrote:
- > Is there an easy way, that I'm
the time then I will send you the options xml and the steps
I used to recreate.
Thanks,
Craig Boyd
David Kerr wrote:
we're on v7.2.8
there's no pg specific option so we've been using ODBC as the
"database" type and the alter's it generates are just ugly.
What version of ERwin are you using?
Thanks,
Craig Boyd
David Kerr wrote:
Is there a default/standard (free) schema diff tool that's in use in
the community?
I'd like to be able to quickly identify new columns, data changes, new
indexes, etc between 2 schema versions.
(and then create an a