How to connect a particular user and create database using PostgreSQL and ubuntu

Question

I need to create a database inside using a particular username and import the .sql file using PostgreSQL and Ubuntu. I have created one user using the below command.

sudo -u postgres createuser user1 -s

I need command to create one database spesh under this particular owner and import the spesh.sql into it.

You're creating a new database for each user? That can't possibly scale to lots of users. Wouldn't a better design be a central repository with a USER table? — duffymo
– duffymo, Commented Sep 7, 2016 at 11:48
@duffymo : i needed to create it under that particular owner. — satya
– satya, Commented Sep 7, 2016 at 11:49

Naizy Monteiro · Accepted Answer · 2016-09-07 12:05:38Z

5

create db spesh with owner user1

sudo -u postgres createdb "spesh" -O user1

import sql dump into spesh database

sudo -u postgres psql spesh < 'file_path.sql'

answered Sep 7, 2016 at 12:05

Naizy Monteiro

765 bronze badges

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

Collectives™ on Stack Overflow

How to connect a particular user and create database using PostgreSQL and ubuntu

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related