postgres not letting me make a database

Question

Why isn't the database there?

postgres=# CREATE USER pavankat WITH PASSWORD 'dfjjelkfjls'
postgres-# CREATE database datathing
postgres-# GRANT RULE ON datathing to pavankat
postgres-# \c lateral-dev
FATAL:  database "lateral-dev" does not exist
Previous connection kept


 which psql
/usr/bin/psql

I have postgres 9.1

I'm using it for a rails application with ruby 2.0 and rails 4.0 and I'm on a computer running Ubuntu 12.04 LTS (32 bit)

Nope not the same thing. Thanks for down voting my question. If you're trying to create a database. You're definitely not looking deleting one. — Pavan Katepalli, Jan 22 '15 at 00:37

score 2 · Accepted Answer · answered Dec 16 '13 at 02:09

2

It needed a semicolon at the end. Like this:

CREATE database datathing;

answered Dec 16 '13 at 02:09

Pavan Katepalli

2,372
4
29
52

postgres not letting me make a database

1 Answers1