Difference between revisions of "PostgreSQL"
From Indie IT Wiki
imported>Plittlefield |
(No difference)
|
Latest revision as of 12:46, 5 September 2013
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