Pgadmin Does CREATE DATABASE but psql does not

Questions and answers regarding general SQL and backend databases

Pgadmin Does CREATE DATABASE but psql does not

Postby cuoredisardegna » Sun Jan 06, 2013 12:30 pm

Hi to All,
I am afraid to make problematic questions about the same subject.

Could Someone resolve?

If a Database "MYDB" is created with Pgadmin there is no problem.

But if it is invoked psql as superuser (postgres) no command is executed. Neiher the other command as "initdb"

Instead if, in psql is typed the command "\l", all DB are seen.

I tried with psql installed in my laptop, in the linux server; with psql of Postgres 8.4.1; 9.0; 9.2, but it was obtained the same effect.

It may be a banal quaestion for You.

Tanks in advance.
Gianni Pinna
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am

Re: Pgadmin Does CREATE DATABASE but psql does not

Postby ROCLASI » Wed Jan 09, 2013 11:35 am

Hi Gianni,

cuoredisardegna wrote:But if it is invoked psql as superuser (postgres) no command is executed. Neiher the other command as "initdb"

Instead if, in psql is typed the command "\l", all DB are seen.

What command are you trying to execute in psql that doesn't work ?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 5 guests

cron