Skip to content

Instantly share code, notes, and snippets.

@sah2ed

sah2ed/Postgres_console_commands.md

Last active December 18, 2023 19:38
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sah2ed/59624add17a395558d32 to your computer and use it in GitHub Desktop.
Save sah2ed/59624add17a395558d32 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgres_console_commands.md 
\i path_to_sql_file
\l - show all databases
\c <db-name> - connect to database
\d - show all tables (including sequences)
\dt - show all tables
\d+ <table-name> - desc table
\dn - show all schemas
\db - show all tablespaces
\q - quit (Ctrl+C)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment