On 03/05/2015 11:01 AM, Igor Neyman wrote:
Sorry, my reply was based on (old) Oracle knowledge.
Now, I'm wondering too, why PG didn't implement such basic (at least to
me) feature.
Per my previous post, see:
http://www.postgresql.org/docs/9.4/interactive/sql-createtable.html
Compatibility
The CREATE TABLE command conforms to the SQL standard, with exceptions
listed below.
Temporary Tables
....
Regards,
Igor Neyman
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
m.b. I'm missing something, but this quote from docs doesn't explain "why", it just states that feature is not implemented.
"The SQL standard also distinguishes between global and local temporary
tables, where a local temporary table has a separate set of contents for
each SQL module within each session, though its definition is still
shared across sessions. Since PostgreSQL does not support SQL modules,
this distinction is not relevant in PostgreSQL.
"
Regards,
Igor Neyman
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
