postgres: create table in database from the command line

Question

I am trying to create a table in postgres, but it ends up in the wrong database.

Here is what I do: in my sql script initially I create a user and a database, and then a table. Code will explain more:

drop database if exists sinfonifry;
drop role if exists sinfonifry;

-- create the requested sinfonifry user

create user sinfonifry createdb createuser password 'some_password';

-- create a sinfonifry database
create database sinfonifry owner sinfonifry;

DROP TABLE if exists sinf01_host;

CREATE TABLE sinf01_host
(
  host_id bigserial NOT NULL, -- The primary key
  host_ip inet NOT NULL, -- The IP of the host
  host_name character varying(255) NOT NULL, -- The name of the host
  CONSTRAINT "PK_host" PRIMARY KEY (host_id )
)
WITH (
  OIDS=FALSE
);

ALTER TABLE sinf01_host OWNER TO sinfonifry;

now, this is part an automated script, and is executed from the command line, like:

sudo -u postgres psql < create_db.sql

and I already have the postgres user created on the system.

And here comes the problem: the table ends up in the postgres database, public schema, not in the sinfonifry database, public schema.

How can I create the table in the database I want to?

Thanks, and cheers, f.

Connect to the freshly created database before creating any objects in it. — wildplasser
– wildplasser, Commented Mar 6, 2013 at 15:18

Clodoaldo Neto · Accepted Answer · 2013-03-06 15:25:36Z

63

After the create database command issue a connect:

create database sinfonifry owner sinfonifry;
\connect sinfonifry

answered Mar 6, 2013 at 15:25

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres: create table in database from the command line

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related