postgresql drop create database

浪人

su - postgres
cd bin
--drop database
./dropdb -U postgres Jedi_SafeNet
--create database
./createdb -E UTF-8 -U postgres Jedi_SafeNet
--excute database script
./psql -d Jedi_SafeNet -f Jedi_SafeNet_DB.TXT  -U postgres

Informational
  \d [NAME]      describe table, index, sequence, or view
  \d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
                 list tables/indexes/sequences/views/system tables
  \da [PATTERN]  list aggregate functions
  \db [PATTERN]  list tablespaces (add "+" for more detail)
  \dc [PATTERN]  list conversions
  \dC            list casts
  <font color="#3333FF">\dd [PATTERN]  show comment for object</font>
  \dD [PATTERN]  list domains
  \df [PATTERN]  list functions (add "+" for more detail)
  \dg [PATTERN]  list groups
  \dn [PATTERN]  list schemas (add "+" for more detail)
  \do [NAME]     list operators
  \dl            list large objects, same as \lo_list
  <font color="#3333FF">\dp [PATTERN]  list table, view, and sequence access privileges</font>
  \dT [PATTERN]  list data types (add "+" for more detail)
  \du [PATTERN]  list users
  <font color="#3366FF">\l             list all databases (add "+" for more detail)</font>
  \z [PATTERN]   list table, view, and sequence access privileges (same as \dp)