postgresql drop create database

最新推荐文章于 2024-08-13 15:51:27 发布

原创最新推荐文章于 2024-08-13 15:51:27 发布 · 260 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#PostgreSQL #Access #F#

database 专栏收录该内容

9 篇文章

订阅专栏

本文总结了PostgreSQL中用于数据库管理的一系列实用命令，包括创建、删除数据库、执行脚本、查看表结构等操作。这些命令对于日常管理和维护PostgreSQL数据库非常有用。

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
\dd [PATTERN] show comment for object
\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
\dp [PATTERN] list table, view, and sequence access privileges
\dT [PATTERN] list data types (add "+" for more detail)
\du [PATTERN] list users
\l list all databases (add "+" for more detail)
\z [PATTERN] list table, view, and sequence access privileges (same as \dp)