i'm a newbie to pgsql (and SQL as well) so please be patient :-)
first, i would like to know all limitations (or call it parameters) of
PostgreSQL 7 (i use 7.0.2). that includes for example, number of
columns in a row, number of rows in a table, number of triggers,
indexes per table. the only limitations i've seen in various sources is
a row size (currently -- 8k) and indexning length of text (something
about 2k). i like many things in PostgreSQL and such information would
help me to evaluate the possibility to use it in bigger projects...
does PoestgreSQL support stored procedures? and will it do, if
it isn't. i could not find any reference on this in docs/htmls...
BTW, about "will it support", is there some roadmap for PostgreSQL?
i've looked at TODO, but hmm :-) it's more detailed than i need...
does PostgreSQL support object naming as "[[[server.]dbname.]
how could i restrict a user from looking what tables are in database
as well as what their structures are. i know i could restrict
select/update/alter/delete/whatever, but can i hide the tables from
a user? also, can PostgreSQL hide some particular columns from user?
the reason for these questions is security, surely. for example i
would create special user (supervisor) and give him all access, after
that i would hide all tables/indexes/whatever and create views,
joining the real tables in any order i like. thus i could install the
database giving nothing away about its internal structure...
sure, i may not use such features, but it would be very good to have
also, could anybody point me to the latest SQL standard (SQL92)?
P.S. why whole world pronounces 'SQL' like 'esquel', while, AFAIK,
IBM proposed it to be pronounced as 'seequel'? :-)
Denis A. Doroshenko -- VAS/IN group engineer
[Address: Omnitel Ltd., T.Sevcenkos 25, Vilnius 2600, Lithuania]