Re: can't create table on new db/schema/user

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: psql-contact(at)citecs(dot)de
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: can't create table on new db/schema/user
Date: 2020-08-28 11:47:56
Message-ID: CAF5nyP9RuyxTKCved5dC6ZJwAE9tvCJ=jZ92+kq2_5McNwAybQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

You must be connected to the database in psql first

\c db_chris
Then create schema ....

Le ven. 28 août 2020 à 13:28, <psql-contact(at)citecs(dot)de> a écrit :

> On Fri, Aug 28, 2020 at 12:56:12PM +0200, hubert depesz lubaczewski wrote:
> > Schema s_chris is in database "postgres", but you try to make the table
> > in "db_chris".
> >
> > So you have to make the schema in db_chris database.
>
> How would I do that?
>
> I ran
> create schema s_chris authorization "chris";
>
> How do I specify the database?
>
> According to
> https://www.postgresql.org/docs/11/sql-createschema.html
>
> there seems to be no such parameter.
>
>
>
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message psql-contact 2020-08-28 12:02:53 [SOLVED] Re: can't create table on new db/schema/user
Previous Message pgsql-novice 2020-08-28 11:47:40 SOLVED: can't create table on new db/schema/user