Re: psql: bogus descriptions displayed by \d+
От | Robert Haas |
---|---|
Тема | Re: psql: bogus descriptions displayed by \d+ |
Дата | |
Msg-id | CA+TgmoZrkmtPqkx8QZd+ZF9WGGrph37wY4XKdBOykL0_-mCfKw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: psql: bogus descriptions displayed by \d+ (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: psql: bogus descriptions displayed by \d+
|
Список | pgsql-hackers |
On Fri, Aug 12, 2011 at 4:11 PM, Peter Eisentraut <peter_e@gmx.net> wrote: > On tor, 2011-08-04 at 14:59 -0400, Robert Haas wrote: >> > Well, the facts are: According to the SQL standard, "table" >> includes >> > views and foreign tables. According to scientific-ish database >> > literature, a table is a relation and vice versa. >> >> So what are you supposed to call it if you mean, specifically, a >> table? > > "A table is either a base table, a derived table, a transient table, or > a viewed table." (SQL/MED adds "foreign table".) > > Just FYI. Base table seems clear enough, and a transient table sounds like a temporary table, but what is a derived table? Is a viewed table a view? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: