From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Patch to allow setting schema/search_path in the connectionURL |
Date: | 2014-09-23 05:23:04 |
Message-ID: | 542103B8.1080208@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On 9/22/2014 10:17 PM, stagirus wrote:
> Your above response almost gave a hope. But not too long.
> All DDLs are going to the public schema. I get the errors as follows:
>
> Error executing SQL CREATE TABLE public.databas...
> Caused by: org.postgresql.util.PSQLException: ERROR: schema "public" does
> not exist
huh. works in SQL.
$ psql
psql (9.3.5)
Type "help" for help.
postgres=# create database test;
CREATE DATABASE
postgres=# \c test
You are now connected to database "test" as user "postgres".
test=# create schema myschema;
CREATE SCHEMA
test=# set search_path to myschema;
SET
test=# drop schema public;
DROP SCHEMA
test=# create table stuff (id serial primary key, val text);
CREATE TABLE
test=# \d
List of relations
Schema | Name | Type | Owner
----------+--------------+----------+----------
myschema | stuff | table | postgres
myschema | stuff_id_seq | sequence | postgres
(2 rows)
test=#
--
john r pierce 37N 122W
somewhere on the middle of the left coast
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2014-09-23 05:24:07 | Re: Patch to allow setting schema/search_path in the connectionURL |
Previous Message | stagirus | 2014-09-23 05:22:42 | Re: Patch to allow setting schema/search_path in the connectionURL |