Show pageOld revisionsBacklinksExport to PDFBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== PostgreSQL ====== ===== Commands ===== ==== Open Shell ==== ''psql -d palliabackend -U palliabackend'' ==== Import data ==== ''psql -d palliabackend -U palliabackend < test_data/foobar.sql'' ===== Shell commands ===== * Connect to database: ''\c dbname username'' * List databases: ''\l'' * List tables: ''\dt'' * Describe table: ''\d table_name'' * List schemas of current database: ''\dn'' * List users: ''\du'' * Command history: ''\s'' * Quit shell: ''\q'' postgresql.txt Last modified: 2020/12/29 02:09by 127.0.0.1