Re: Proper relational database?

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