need an information on PostgreSQL
От | Denis A. Doroshenko |
---|---|
Тема | need an information on PostgreSQL |
Дата | |
Msg-id | 20001109103753.N9377@comrade.omnitel.lan обсуждение исходный текст |
Ответы |
Re: need an information on PostgreSQL
Re: need an information on PostgreSQL |
Список | pgsql-general |
Hello, 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.] owner.]objectname"? 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 them... also, could anybody point me to the latest SQL standard (SQL92)? advTHANKSance. 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] [Phone: +370 98 63207] [E-mail: mailto:d.doroshenko@omnitel.net]
В списке pgsql-general по дате отправления: