Skip to content

Instantly share code, notes, and snippets.

@ramazanpolat

ramazanpolat/postgres-01

Last active June 10, 2019 14:37
Show Gist options
  • Save ramazanpolat/e93c06c26b227c7b90ca9ee1015d37db to your computer and use it in GitHub Desktop.
Save ramazanpolat/e93c06c26b227c7b90ca9ee1015d37db to your computer and use it in GitHub Desktop.
Download ZIP
Command for first time PostgreSQL 11 users
Raw
postgres-01
### 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