Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 527621337B80
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 27 Apr 2011 15:45:48 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 45982-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 27 Apr 2011 18:45:28 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from pp-ag1.abag.ca.gov (pp-ag1.abag.ca.gov [198.31.87.11])
	by mail.postgresql.org (Postfix) with ESMTP id 4EB581337C40
	for <pgsql-admin@postgresql.org>; Wed, 27 Apr 2011 15:45:11 -0300 (ADT)
Received: from pps.filterd (pp-ag1 [127.0.0.1])
	by pp-ag1.abag.ca.gov (8.14.4/8.14.4) with SMTP id p3RIjAHx007197
	for <pgsql-admin@postgresql.org>; Wed, 27 Apr 2011 11:45:10 -0700
Received: from gwia1.abag.ca.gov ([172.16.1.27])
	by pp-ag1.abag.ca.gov with ESMTP id vxp77825u-1
	for <pgsql-admin@postgresql.org>; Wed, 27 Apr 2011 11:45:09 -0700
Received: from d02-MTA by gwia1.abag.ca.gov
	with Novell_GroupWise; Wed, 27 Apr 2011 11:44:46 -0700
Message-Id: <4DB801AD020000A700017012@gwia1.abag.ca.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.2 
Date: Wed, 27 Apr 2011 11:44:45 -0700
From: "Fred Parkinson" <FredP@abag.ca.gov>
To: <pgsql-admin@postgresql.org>
Subject: Starting psql without a database?
References: <4DB7EF0B020000A700017002@gwia1.abag.ca.gov>
	<4DB801AD020000A700017012@gwia1.abag.ca.gov>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=__PartF4D80C0D.0__="
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15, 1.0.148,
	0.0.0000
	definitions=2011-04-27_07:2011-04-27, 2011-04-27,
	1970-01-01 signatures=0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201104/238
X-Sequence-Number: 37419

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=__PartF4D80C0D.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Folks
=20
As I have been unable to install pgadmin3 on my OpenSUSE Linux 10 box =
(erroneously described as 11.2 in the request for help post, that was =
useless), I have decided to use psql since it seems to be my only option.
=20
However, I have no database as yet, and when I type in a console 'psql' I =
get the message "psql: FATAL: database 'username' does not exist"
So I try to start by sending the createdb command, as in: "psql -c =
createdb -T DEFAULT 'timecard'" but this returns the error "psql: FATAL:  =
database "timecard" does not exist"
=20
I tried using the database 'postgres' which seems to be created during the =
install:
psql postgres, which takes me to a psql prompt.  However, the command =
createdb -T DEFAULT "timecard" now results in the error "syntax error at =
or neat "createdb" with a carat pointing to the 'c' in 'createdb'.
=20
As usual, stuck again!
=20
Any ideas greatly appreciated.
Fred

--=__PartF4D80C0D.0__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META content=3D"text/html; charset=3Dutf-8" http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.19046"></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Arial; COLOR: #000000">
<DIV>Folks</DIV>
<DIV>&nbsp;</DIV>
<DIV>As I have been unable to install pgadmin3 on my OpenSUSE Linux 10 box =
(erroneously described as 11.2 in the request for help post, that was =
useless), I have decided to use psql since it seems to be my only =
option.</DIV>
<DIV>&nbsp;</DIV>
<DIV>However, I have no database as yet, and when I type in a console =
'psql' I get the message "psql: FATAL: database 'username' does not =
exist"</DIV>
<DIV>So I try to start by sending the createdb command, as in: "psql -c =
createdb -T DEFAULT 'timecard'" but this returns the error "psql: =
FATAL:&nbsp; database "timecard" does not exist"</DIV>
<DIV>&nbsp;</DIV>
<DIV>I tried using the database 'postgres' which seems to be created =
during the install:<BR>psql postgres, which takes me to a psql prompt.&nbsp=
; However, the command createdb -T DEFAULT "timecard" now results in the =
error "syntax error at or neat "createdb" with a carat pointing to the 'c' =
in 'createdb'.</DIV>
<DIV>&nbsp;</DIV>
<DIV>As usual, stuck again!</DIV>
<DIV>&nbsp;</DIV>
<DIV>Any ideas greatly appreciated.</DIV>
<DIV>Fred</DIV></BODY></HTML>

--=__PartF4D80C0D.0__=--