4,461
edits
Introduction to PostgreSQL for MySQL Users: Difference between revisions
Introduction to PostgreSQL for MySQL Users (view source)
Revision as of 16:44, 29 August 2016
, 29 August 2016→listing all tables: add Change the password of a user
→selecting a DB: add listing all tables |
→listing all tables: add Change the password of a user |
||
| Line 73: | Line 73: | ||
<syntaxhighlight lang="psql"> | <syntaxhighlight lang="psql"> | ||
postgres=# \dt | postgres=# \dt | ||
</syntaxhighlight> | |||
== Change the password of a user == | |||
You can list tables in a DB. | |||
MySQL: | |||
<syntaxhighlight lang="mysql"> | |||
mysql> set password for 'dbuser'@'localhost' = password('newpassword'); | |||
</syntaxhighlight> | |||
PostgreSQL: | |||
<syntaxhighlight lang="psql"> | |||
postgres=# alter user "dbuser" with password 'newpassword'; | |||
</syntaxhighlight> | </syntaxhighlight> | ||