Psql powerful, skills how to use only follow-up slowly supplemented, see a tool first see how to use Help$ psql #连接到数据库服务器, in which you can enter the appropriate SQL statement or PSQL command, psql command starts with \$ \l #列出所有的数据库$ \d #查看表的结构$
The command syntax for Psql is:psql [Options] [dbname [username]]The Psql command-line options and their meanings are listed in table 1-1. Use the following command to see a complete list of options for Psql:$ psql--helpTable 1-1 psql command-line
D:\Program files\postgresql\9.3\scriptsThis is the default buffer position of the psql;Psql's command: D:\Program files\postgresql\9.3\scripts\runpsql.bat--Query buffer\e [file] [line] Edit query buffer (or file) using external editor\EF [FUNCNAME
\?-------------------------------------General\copyright display the use and release license terms for PostgreSQL\g [file] or; Execute the query (and write the results to a file or | pipeline)\gset [PREFIX] executes the query and saves the result to
PostgreSQL tutorial (18): client commands (2), postgresql tutorial
VII. pg_dump:
Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking
Seven, Pg_dump:
Pg_dump is a tool for backing up the PostgreSQL database. It can even make a full, consistent backup when the database is being used concurrently, without blocking access to the database by other users. The dump format generated by
Recently, the company was using the postgresql database and developed many ddldml statements for us. So I spent two days completing this script to Create Table spaces and users, script for automatic data import #! Binbas
Recently, the company was
According to my understanding of the four domestic databases, three of which are based on PostgreSQL development. And, because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for any purpose, whether for private,
The Linux release version is Ubuntu server 6.06, And the Ubuntu version is only 8.1. To be an early adopter, 8.2.0 has improved the compatibility based on the Windows platform to facilitate the conversion of the platform. At the same time, you can
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.