On Oct 2, 2012, at 12:30 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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