| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Josh Kupershmidt <schmiddy(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: psql: bogus descriptions displayed by \d+ |
| Date: | 2011-08-12 20:14:46 |
| Message-ID: | CA+TgmoZrkmtPqkx8QZd+ZF9WGGrph37wY4XKdBOykL0_-mCfKw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Aug 12, 2011 at 4:11 PM, Peter Eisentraut <peter_e(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PostgreSQL - Hans-Jürgen Schönig | 2011-08-12 20:21:25 | Re: index-only scans |
| Previous Message | Peter Eisentraut | 2011-08-12 20:11:13 | Re: psql: bogus descriptions displayed by \d+ |