limits?

How can I find the limits (if any) on things such as the maximum number of
tables, views, indices, columns-per-table, size of database, etc.?

(At the moment I'm particularly interested any limits that my exist on the
numbers of tables and views that may exist in any one database.)

TIA!

Kynn

Thomas Kellerer wrote:
Steve Atkins wrote on 23.06.2008 20:21:
In real use you're unlikely to hit any limits, theoretical or practical,

I imagine that the 1GB column-value limit is something that could be
reached though. Especially for BLB (aka bytea) or CLB (aka text) columns.

No, since they are stored out of band (toast tables). For *lob there is
a lob type which stored the data completely separate, not to be confused
with bytea and text (varchar).

Tino.