Tuesday, September 11, 2012

postgressql 9.15 help commands


  ALTER TEXT SEARCH CONFIGURATION  DROP SEQUENCE
  ALTER TEXT SEARCH DICTIONARY     DROP SERVER
  ALTER TEXT SEARCH PARSER         DROP TABLE
  ALTER TEXT SEARCH TEMPLATE       DROP TABLESPACE
  ALTER TRIGGER                    DROP TEXT SEARCH CONFIGURATION
  ALTER TYPE                       DROP TEXT SEARCH DICTIONARY
  ALTER USER                       DROP TEXT SEARCH PARSER
  ALTER USER MAPPING               DROP TEXT SEARCH TEMPLATE
  ALTER VIEW                       DROP TRIGGER
  ANALYZE                          DROP TYPE
  BEGIN                            DROP USER
  CHECKPOINT                       DROP USER MAPPING
  CLOSE                            DROP VIEW
  CLUSTER                          END
  COMMENT                          EXECUTE
  COMMIT                           EXPLAIN
  COMMIT PREPARED                  FETCH
  COPY                             GRANT
  CREATE AGGREGATE                 INSERT
  CREATE CAST                      LISTEN
  CREATE COLLATION                 LOAD
  CREATE CONVERSION                LOCK
  CREATE DATABASE                  MOVE
  CREATE DOMAIN                    NOTIFY
  CREATE EXTENSION                 PREPARE
  CREATE FOREIGN DATA WRAPPER      PREPARE TRANSACTION
  CREATE FOREIGN TABLE             REASSIGN OWNED
  CREATE FUNCTION                  REINDEX
  CREATE GROUP                     RELEASE SAVEPOINT
  CREATE INDEX                     RESET
  CREATE LANGUAGE                  REVOKE
  CREATE OPERATOR                  ROLLBACK
  CREATE OPERATOR CLASS            ROLLBACK PREPARED
  CREATE OPERATOR FAMILY           ROLLBACK TO SAVEPOINT
  CREATE ROLE                      SAVEPOINT
  CREATE RULE                      SECURITY LABEL
  CREATE SCHEMA                    SELECT
  CREATE SEQUENCE                  SELECT INTO
  CREATE SERVER                    SET
  CREATE TABLE                     SET CONSTRAINTS




 \copyright             show PostgreSQL usage and distribution terms
  \g [FILE] or ;         execute query (and send results to file or |pipe)
  \h [NAME]              help on syntax of SQL commands, * for all commands
  \q                     quit psql

Query Buffer
  \e [FILE] [LINE]       edit the query buffer (or file) with external editor
  \ef [FUNCNAME [LINE]]  edit function definition with external editor
  \p                     show the contents of the query buffer
  \r                     reset (clear) the query buffer
  \s [FILE]              display history or save it to file
  \w FILE                write query buffer to file

Input/Output
  \copy ...              perform SQL COPY with data stream to the client host
  \echo [STRING]         write string to standard output
  \i FILE                execute commands from file
  \o [FILE]              send all query results to file or |pipe
  \qecho [STRING]        write string to query output stream (see \o)

Informational
  (options: S = show system objects, + = additional detail)
  \d[S+]                 list tables, views, and sequences
  \d[S+]  NAME           describe table, view, sequence, or index
  \da[S]  [PATTERN]      list aggregates
  \db[+]  [PATTERN]      list tablespaces
  \dc[S]  [PATTERN]      list conversions
  \dC     [PATTERN]      list casts
  \dd[S]  [PATTERN]      show comments on objects
  \ddp    [PATTERN]      list default privileges
  \dD[S]  [PATTERN]      list domains
  \det[+] [PATTERN]      list foreign tables
  \des[+] [PATTERN]      list foreign servers
  \deu[+] [PATTERN]      list user mappings
  \dew[+] [PATTERN]      list foreign-data wrappers
  \df[antw][S+] [PATRN]  list [only agg/normal/trigger/window] functions
  \dF[+]  [PATTERN]      list text search configurations
  \dFd[+] [PATTERN]      list text search dictionaries
  \dFp[+] [PATTERN]      list text search parsers
Formatting
  \a                     toggle between unaligned and aligned output mode
  \C [STRING]            set table title, or unset if none
  \f [STRING]            show or set field separator for unaligned query output
  \H                     toggle HTML output mode (currently off)
  \pset NAME [VALUE]     set table output option
                         (NAME := {format|border|expanded|fieldsep|footer|null|
                         numericlocale|recordsep|tuples_only|title|tableattr|pager})
  \t [on|off]            show only rows (currently off)
  \T [STRING]            set HTML tag attributes, or unset if none
  \x [on|off]            toggle expanded output (currently off)

Connection
  \c[onnect] [DBNAME|- USER|- HOST|- PORT|-]
                         connect to new database (currently "postgres")
  \encoding [ENCODING]   show or set client encoding
  \password [USERNAME]   securely change the password for a user
  \conninfo              display information about current connection

Operating System
  \cd [DIR]              change the current working directory
  \timing [on|off]       toggle timing of commands (currently off)
  \! [COMMAND]           execute command in shell or start interactive shell

Variables
  \prompt [TEXT] NAME    prompt user to set internal variable
  \set [NAME [VALUE]]    set internal variable, or list all if no parameters
  \unset NAME            unset (delete) internal variable

Large Objects
  \lo_export LOBOID FILE
  \lo_import FILE [COMMENT]
  \lo_list
  \lo_unlink LOBOID      large object operations



1 comment:

  1. BlueHost is ultimately one of the best hosting provider for any hosting plans you might require.

    ReplyDelete