psql command line examples

1, command line login database There are two ways to execute the psql command directly under the system shell, but to enter the PSQL environment first and then connect to the database. Examples are given below: (1) Direct login Execute command:

1 Command line logon databaseThere are two ways to execute the psql command directly under the system shell, instead of entering the PSQL environment before connecting to the database. Examples are given below:(1) Direct loginExecute command:psql-h 1

Operating system version[Root@web103 ~]# More/etc/issueCentOS release 5.9 (Final)Kernel \ r \m[Root@web103 ~]# Uname-aLinux web103 2.6.18-348.el5 #1 SMP Tue 8 17:53:53 EST 2013 x86_64 x86_64 x86_64 gnu/linuxdownload corresponding PostgreSQL

Backup and restore are most important when you are transporting a database. Today, we tested backup and restore using Pg_dumpall. Backup Restore method: Pg_dump and Pg_restore, first carefully explain these two commands Back up the database,

Once you have created the database, you can access it: Terminal program psql , which runs PostgreSQL interaction, allows you to interactively enter, edit, and execute SQL commands. Create and manage databases using our existing

First, installationNaturally, before you can start using PostgreSQL, you must install it. PostgreSQL is probably already installed on your node because it may be included in the release of your operating system, or the system administrator has

PostgreSQL has become the first choice for open source relational databases since it was acquired by Oracle. This article introduces the installation and basic usage of PostgreSQL for the first time users. The following content is based on the

: Network Disk DownloadContent Profile ...This book will help you understand and use the PostgreSQL open source database system. Not only will you learn about enterprise features in versions 9.2, 9.3, and 9.4, but you'll also find that PostgreSQL is

Have you ever accidentally deleted a database table or damaged the disk where the database is stored? If you encounter this situation, I believe you will feel very frustrated, because the results of your hard work for a few weeks may be overwhelmed.

(1) User PracticalityProgram: Createdb creates a new PostgreSQL database (same as SQL statement: Create Database) Createuser creates a new PostgreSQL user (same as SQL statement: create user) Dropdb deletes a database Dropuser: delete a user