Apache2Triad Help, Support and Development

[ioconnor]

Ok, simple yet stupid questions. First here's the log:


c:\apache2triad1\pgsql\bin>psql -h localhost -u xyz
psql: Warning: The -u option is deprecated. Use -U.
User name: root
Password for user ☺:
Welcome to psql 8.1.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.

xyz-# \quit

c:\apache2triad1\pgsql\bin>psql -h localhost -U xyz
psql: FATAL: role "xyz" does not exist


Now you see how it comes back saying -u is deprecated and tells me to use the uppercase version. So I give it a try and it comes back telling me something totally different. I assume that psql has a bug and they meant to say something else. Like -u is deprecated, use something else. What would that something else be?

I'd like to be able to log directly in from the command line and execute script xyzt at the same time. What's the proper syntax for this?

The next concern I have is the code page. How do I fix it so I don't get any warnings?

==========================

Ok, I figured out that is should be psql -h localhost -d xyz -U root

Still working on the code page...