On Sat, Apr 23, 2016 at 1:53 AM, Guyren Howe <guyren@gmail.com> wrote:
> On Apr 22, 2016, at 18:56 , <david@andl.org> <david@andl.org> wrote:
> Why schema-on-demand? Can you explain what you mean by that?
>
> Something that is attractive, for beginners or perhaps when prototyping is
> that you don't have to declare a table. You can just insert tuples into a
> predicate whose name you provide and they go in and you've defined a
> relation just by using it.
test=# \d
No relations found.
test=# select * into people from (values (1,'Fred'), (2, 'Bob')) x(id, name);
SELECT 2
test=# select * from people;
id | name
----+------
1 | Fred
2 | Bob
(2 rows)
test=# \d
List of relations
Schema | Name | Type | Owner
--------+--------+-------+---------
public | people | table | kgrittn
(1 row)
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company