Hi!
On Tue, 20 Apr 1999, Jackson, DeJuan wrote:
> The reason I chose those tow columns is because they are the only one that
> will be seen in that where clause.
> So position should be indexed on subsec_id, status, and pos_id.
Sounds reasonable.
> My general rule of thumb is to stay away
Btw. of indices:
is there a way to add to index boolean type?
I have a table from which I get records with clause where on four columns.
One is text, second is int and two other are bool.
I need to get data from this table in most effective way, but for now have
no indices cause when I try bool_o
--retrieve column information...
SELECT a.attnum, a.attname,
t.typname, a.attlen,
a.atttypmod, a.attnotnull,
a.atthasdef
FROM pg_class c, pg_attribute
a, pg_type t
WHERE c.relname = 'comuni'
and a.attnum > 0
and a.attrelid = c.oid
Umm. I need to know the type of the _object_, not the types of the
attributes contained therein.
José Soares wrote:
>
> --retrieve column information...
>
> SELECT a.attnum, a.attname, t.typname, a.attlen,
> a.atttypmod, a.attnotnull, a.atthasdef
> FROM pg_class c, pg_
I've just read through the FAQ on the postgresql.org homepage and I can't
seem to find any reference to my problem so I'm resorting to asking the
question here. If the answer to my question is found in another FAQ
somewhere, please point me in the correct direction.
Anyway, I'm writing a program
> I've just read through the FAQ on the postgresql.org homepage and I can't
> seem to find any reference to my problem so I'm resorting to asking the
> question here. If the answer to my question is found in another FAQ
> somewhere, please point me in the correct direction.
>
> Anyway, I'm writi
On Wed, 21 Apr 1999, Bruce Momjian wrote:
> I thought we fixed that in 6.4 so bool was not visible to outside
> applications. You probably can comment it out of libpq.h.
You know, I'm not sure what version of the database I'm running. It may
very well be that this is an older version (<6.4) an
I am looking for a freeware tool to document my postgres database
tables, indices, etc.
A friend of mine uses ERwin, but this is a licensed package his company
had to buy. I
Are there any free software tools that people use to create entity
relationship diagrams
and to document databases?
Thanks
