11/13/2023 0 Comments Mycli postgres![]() If you do not supply the database name then it will default to your user account name. It can be activated for the mydb database by typing the command: $ psql mydb You probably want to start up psql to try the examples in this tutorial. These possibilities are discussed further in Part IV. Writing a custom application, using one of the several available language bindings. These possibilities are not covered in this tutorial. Using an existing graphical frontend tool like pgAdmin or an office suite with ODBC or JDBC support to create and manipulate a database. 有两种类型的键绑定,分别是 Emacs 模式(默认)和 Vi 模式,可以通过配置文件 (~/.Running the PostgreSQL interactive terminal program, called psql, which allows you to interactively enter, edit, and execute SQL commands. | \watch | Execute query every `sec` seconds. | \sf FUNCNAME | Show a function's definition. | \pset | A limited version of traditional \pset | | \np name_pattern | Print a named query. | \i filename | Execute commands from file. | \e | Edit the query with external editor. | \ddp | Lists default access privilege settings. | \d | List or describe tables, views and sequences. | \copy to/from | Copy data between a file and a table. | \c database_name | Change to a new database. | \T | Change the table format used to output results | ssh-tunnel TEXT Open an SSH tunnel to the given address and warn Warn before running a destructive query. The result is wider than the terminal width. auto-vertical-output Automatically switch to vertical output mode if l, -list list available databases, then exit. ![]() prompt-dsn TEXT Prompt format for connections using DSN aliases less-chatty Skip intro on startup and goodbye on exit. row-limit INTEGER Set threshold for row limit prompt. ![]() list-dsn list of DSN configured into the D, -dsn TEXT Use DSN configured into the section d, -dbname TEXT database name to connect to. single-connection Do not use a separate connection for completions. w, -no-password Never prompt for password. u, -user TEXT Username to connect to the postgres database. U, -username TEXT Username to connect to the postgres database. p, -port INTEGER Port number at which the postgres instance is h, -host TEXT Host address of the postgres database. doneįound existing installation: psycopg2 2.9.1 Successfully uninstalled importlib-metadata-4.8.1 Successfully uninstalled typing-extensions-3.10.0.2įound existing installation: importlib-metadata 4.8.1 Installing collected packages: typing-extensions, importlib-metadata, click, Pygments, sqlparse, configobj, pytzdata, pendulum, prompt-toolkit, setproctitle, tabulate, cli-helpers, psycopg2, pgspecial, pgcliįound existing installation: typing-extensions 3.10.0.2 Requirement already up-to-date: zipp>=0.5 in /usr/local/lib/python3.6/site-packages (from importlib-metadata python_version click>=4.1->pgcli)Ĭollecting typing-extensions>=3.6.4 python_version click>=4.1->pgcli) Requirement already up-to-date: wcwidth in /usr/local/lib/python3.6/site-packages (from prompt-toolkit=2.0.6->pgcli)Ĭollecting tabulate>=0.8.2 (from cli-helpers>=2.2.1->pgcli) Requirement already up-to-date: python-dateutil=2.6 in /usr/local/lib/python3.6/site-packages (from pendulum>=2.1.0->pgcli) WARNING: Running pip install with root privileges is generally not a good idea.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |