Many thanks Now I enter c:\Program Files\PostgreSQL\8.3\bin\createdb mydb; PG asks me password Is the password as superadmin's password or postgre's password what I set when postgresql installed in windows I try both, but does not work" user administrator password fail" so How to log on as superadmin.
long On Thu, Jul 3, 2008 at 11:58 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote: > On 03/07/2008 14:40, Long Cui wrote: > >> I install PostgreSQL 8.3.3 in Windows XP, and set Path environment >> viarable to C:\Program Files\PostgreSQL\8.3\bin, when I enter "create >> database mydb;" it successed, however when "createdb mydb;" told me syntax >> error. Dose the Path set wrong or I need to set other viarables? >> > > It sounds as if you're issuing the commands from within psql - hence the > standard SQL "create database...." works, but "createdb.." won't. > > createdb is just a wrapper program that sends a "create database..." > command to the server, so you need to run it from the Windows command-line. > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > [EMAIL PROTECTED] > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ >
