Last active
June 10, 2019 14:37
-
-
Save ramazanpolat/e93c06c26b227c7b90ca9ee1015d37db to your computer and use it in GitHub Desktop.
Command for first time PostgreSQL 11 users
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### installation | |
| ### connection | |
| su - postgres | |
| psql | |
| #### psql commands | |
| # connect to a database | |
| \connect dbname | |
| # get current database | |
| select current_database(); | |
| # get tables in current database | |
| SELECT * FROM pg_catalog.pg_tables; | |
| \dt | |
| ### postgresql.conf | |
| nano /var/lib/pgsql/11/data/postgresql.conf |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment