By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Invoking psql at command prompt

shoonya
100+
P: 161
hello all
I am just started migrated from WAMP to WAPP
can any body tell me how to run postgreSQL from command prompt??

shoonya
May 11 '07 #1
Share this Question
Share on Google+
6 Replies


Expert 100+
P: 534
What do you mean by "run postgreSQL"?

If you need to start the database server look at pg_ctl,
if you need to open the interactive terminal and run your SQL commands look at psql
May 12 '07 #2

shoonya
100+
P: 161
What do you mean by "run postgreSQL"?

If you need to start the database server look at pg_ctl,
if you need to open the interactive terminal and run your SQL commands look at psql
i tried psql command on command prompt but it's giving errors
"unrecognized command"
i think i am doing some basic error
so any help will be appriciated
May 14 '07 #3

Expert 100+
P: 534
Try to either use the fully qualified path, or cd to the directory where psql is installed, or add the directory where psql is installed to the path variable in your environment.

It appears that you report your own postings. There's no need to do that, it won't help you to get the answer sooner.
May 14 '07 #4

shoonya
100+
P: 161
Try to either use the fully qualified path, or cd to the directory where psql is installed, or add the directory where psql is installed to the path variable in your environment.

It appears that you report your own postings. There's no need to do that, it won't help you to get the answer sooner.
i am not reporting my posts
just clicked on the report button instead on reply one[;)]
while setting the path to the location of psql
it's giving warning about window code page 1252
May 15 '07 #5

Expert 100+
P: 534
In most cases you can disregard this warning about code page.
But if you do want to try something new here's the info that may help.

psql on Windows is built as a "console application". Since the Windows console windows use a different encoding than the rest of the system, you must take special care when using 8-bit characters within psql. If psql detects a problematic console code page, it will warn you at startup. To change the console code page, two things are necessary:

1) Set the code page by executing cmd.exe /c chcp 1252. (you may need to replace 1252 with your value.)

2) Set the console font to "Lucida Console", because the raster font does not work with the ANSI code page.

Read the psql manual for more information.
May 15 '07 #6

shoonya
100+
P: 161
In most cases you can disregard this warning about code page.
But if you do want to try something new here's the info that may help.

psql on Windows is built as a "console application". Since the Windows console windows use a different encoding than the rest of the system, you must take special care when using 8-bit characters within psql. If psql detects a problematic console code page, it will warn you at startup. To change the console code page, two things are necessary:

1) Set the code page by executing cmd.exe /c chcp 1252. (you may need to replace 1252 with your value.)

2) Set the console font to "Lucida Console", because the raster font does not work with the ANSI code page.

Read the psql manual for more information.

great man...
thanks a ton[:)]
May 16 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.