Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

SQL - Command

back

• SQL - Command
  • SHOW: Return information about Runtime parameter
  • Import/Export

---

SHOW: Return information about Runtime parameter

-- show all info 
SHOW ALL

-- return the current time zone
SHOW TIMEZONE

---

Import/Export

• Allow to import data from CSV file to an existing table.

• Import command does not create a table, but assumes a tableis already created.

• Documentation:

  • https://www.postgresql.org/docs/current/sql-copy.html

---

TOP