Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 "psql -h localhost -u xyz" problems
Google
Post new topic Reply to topic
Author Message
ioconnor
 
 


Joined: 01 Apr 2006
Posts: 4

PostPosted: Sun Apr 16, 2006 6:24 pm Reply with quoteBack to top

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...
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT