From: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
---|---|
To: | Guyren Howe <guyren(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Proper relational database? |
Date: | 2016-04-23 09:19:02 |
Message-ID: | CACjxUsN9L06S=fqQA1GOxUvQ_OcyyCg2HtFef7Jswo3T1uE=4g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Apr 23, 2016 at 1:53 AM, Guyren Howe <guyren(at)gmail(dot)com> wrote:
> On Apr 22, 2016, at 18:56 , <david(at)andl(dot)org> <david(at)andl(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-04-23 13:17:05 | Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created |
Previous Message | Guyren Howe | 2016-04-23 06:53:00 | Re: Proper relational database? |