PostgreSQL commands

• ALTER ROLE (An SQL command for modifying a database role)
  • Description
  • Description
• PostgreSQL common commands
  • dump de database
  • create schema
  • Modification du search_path pour le rôle log
  • Afficher le search_path
  • conninfo
  • drds (Lists defined configuration settings)
  • dconfig (Lists server configuration parameters and their values)
  • Import au format texte
  • Alternative roles, search_path, show search_path
• createdb
  • which createdb
  • createdb –help
  • Examples
• CREATE DATABASE (An SQL command to create a database)
  • Description
• createuser
  • which createuser
  • Examples
• CREATE ROLE (An SQL command for creating a database role)
  • Description
  • Description
• CREATE SCHEMA (An SQL command for defining a new schema)
  • Description
  • Description
  • Examples
    • Create a schema for user joe; the schema will also be named joe
• pg_commands
• pg_dump extract a PostgreSQL database into a script file or other archive file
  • Description
    • pg_dump –help
    • man pg_dump
    • pg_dump examples
• pg_restore restore a PostgreSQL database from an archive file created by pg_dump
  • Description
    • pg_restore –help
    • man pg_restore
    • pg_restore examples