Horton
Menu

Re: CREATE SCHEMA IF NOT EXISTS

David E. Wheeler <david@justatheory.com>

View thread
From: "David E. Wheeler" <david@justatheory.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Dickson S. Guedes <listas@guedesoft.net>, fabriziomello <fabriziomello@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-10-02T19:37:30Z
Lists: pgsql-hackers 
On Oct 2, 2012, at 12:30 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

> How about call this for precedent:
> 
> mkdir -p /tmp/foo/bar
> mkdir -p /tmp/foo/baz
> 
> In this case you end up with directory "foo" and at least two subdirs in
> it, bar and baz.  This works even if /tmp/foo existed previously and
> even if there was some other stuff in it.

Well, what about this, then?

create schema if not exists foo create table second (a int);
create schema if not exists foo create table second (b int);

David

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Document the lack of reading the PGDATABASE environment variable in