PostgreSQL

From Indie IT Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
sudo su - postgres
psql -d template1 -U postgres
template1=# \c databasename
You are now connected to database "databasename" as user "postgres".
databasename=# \dt
databasename=# \dt
databasename=# SELECT * FROM res_users;

http://crashmag.net/resetting-the-rootpostgres-password-for-postgresql

http://www.postgresql.org/docs/9.1/static/tutorial-select.html