Re: need an information on PostgreSQL

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Denis A(dot) Doroshenko" <d(dot)doroshenko(at)omnitel(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: need an information on PostgreSQL
Date: 2000-11-09 16:33:53
Message-ID: Pine.LNX.4.21.0011091721280.1244-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Denis A. Doroshenko writes:

> 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.

See FAQ. (Anything not mentioned there is relatively unlimited.)

> does PoestgreSQL support stored procedures? and will it do, if
> it isn't. i could not find any reference on this in docs/htmls...

We have user-defined functions, but they can only return one value, which
is unlike what most people expect.

> 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...

Mostly, we just implement what we feel like. Stored procedure support is
high on many people's lists though.

> does PostgreSQL support object naming as "[[[server.]dbname.]
> owner.]objectname"?

Nope.

> how could i restrict a user from looking what tables are in database
> as well as what their structures are.

You can't.

> also, could anybody point me to the latest SQL standard (SQL92)?

The latest standard is SQL99 and you can buy it from your local ISO
approved standardization organization. But reading it is not a pleasant
experience; you better buy a book.

> P.S. why whole world pronounces 'SQL' like 'esquel', while, AFAIK,
> IBM proposed it to be pronounced as 'seequel'? :-)

Who cares about IBM? If they wanted to have it pronounced 'seequel' they
should have named it 'seequel'. :-)

Oh, and on the "whole world" scale I think "ess-queue-ell" (or local
tongue variations) wins hand down.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mike focosi 2000-11-09 16:38:39 Table Corruption
Previous Message Jim Mercer 2000-11-09 16:24:28 Re: libpq: Char to INT