Skip to content

Instantly share code, notes, and snippets.

@semihozkoroglu

semihozkoroglu/postgres

Last active December 26, 2015 10:39
Show Gist options
  • Save semihozkoroglu/7138051 to your computer and use it in GitHub Desktop.
Save semihozkoroglu/7138051 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres
- sudo su - postgres // Change current user
- psql <dbname> // Connect to DB with selected user
- \list // Show all database
- \dt // List all tables in the current database
- \d <tablename> // Describe table
- select user_name, directory_id, display_name, email_address from cwd_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment