Skip to content

Instantly share code, notes, and snippets.

@BumbuKhan

BumbuKhan/PostgreSQL

Last active March 2, 2017 14:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save BumbuKhan/4690661b45abc581e11c1bb0090cfc75 to your computer and use it in GitHub Desktop.
Save BumbuKhan/4690661b45abc581e11c1bb0090cfc75 to your computer and use it in GitHub Desktop.
Download ZIP
Work with tables in PostgreSQL
Raw
PostgreSQL
List of available databases: \l
List of available tables: \dt
Choose table: \c <table_name>
Quit session: \q
@BumbuKhan
Copy link
Author

BumbuKhan commented Mar 2, 2017 •
edited

Read more: https://postgrespro.ru/media/2017/02/20/introbook_v3b1.pdf#viewer.action=download
List of commands on page 48

@BumbuKhan
Copy link
Author

Read about schemas: http://postgresql.ru.net/manual/ddl-schemas.html

@BumbuKhan
Copy link
Author

How to dump only schema (without data) http://serverfault.com/questions/60658/how-can-i-do-a-dump-of-only-the-table-structure-in-postgresql - "pg_dump --schema-only"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment