how to run postgresql on debian terminal

[manjuscripts]

I installed postgresql on debian and i want to run it on the terminal.some body can do me that favour

[rski]

To start server you can use command

pg_ctl start

To connect to database you can use psql client

psql database_name

[pgadmin]

follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database
8. type exit to close postgresql database

[pgadmin]

follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database
8. type exit to close postgresql database

[Pramod Gautam]

Hi, I am using Debian etch with postgresql database. I used this procedure for start postgre database on my terminal
follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database
8. type exit to close postgresql database