Command line for PostgreSQL in Ubuntu

1.Start data base

sudo /etc/init.d/postgresql-8.4 start

2. Login to your database in this case my data base name is Research0_development and username is chada

psql -d Research0_development -U chada

3. command for examine the database

• \l :List databases
• \c database-name :List databases
• \d :List tables in database
• \d table-name escribe table
• \q : quit
• select * from table-name :List table contents
• delete from table where condition =>

delete from place_ratings where user_id = 49;

 

 

Advertisement