Doculus

Manuals

User commands

clusterdb(1)

Cluster a PostgreSQL database

createdb(1)

Create a new PostgreSQL database

createlang(1)

Define a new PostgreSQL procedural language

createuser(1)

Define a new PostgreSQL user account

dropdb(1)

Remove a PostgreSQL database

droplang(1)

Remove a PostgreSQL procedural language

dropuser(1)

Remove a PostgreSQL user account

ecpg(1)

Embedded SQL C preprocessor

initdb(1)

Create a new PostgreSQL database cluster

ipcclean(1)

Remove shared memory and semaphores from a failed PostgreSQL server

pg_config(1)

Retrieve information about the installed version of PostgreSQL

pg_controldata(1)

Display control information of a PostgreSQL database cluster

pg_ctl(1)

Start, stop, or restart a PostgreSQL server

pg_dump(1)

Extract a PostgreSQL database into a script file or other archive file

pg_dumpall(1)

Extract a PostgreSQL database cluster into a script file

pg_resetxlog(1)

Reset the write-ahead log and other control information of a PostgreSQL database cluster

pg_restore(1)

Restore a PostgreSQL database from an archive file created by pg_dump

postgres(1)

Run a PostgreSQL server in single-user mode

postmaster(1)

PostgreSQL multiuser database server

psql(1)

PostgreSQL interactive terminal

reindexdb(1)

Reindex a PostgreSQL database

vacuumdb(1)

Garbage-collect and analyze a PostgreSQL database

Miscellaneous

abort(7)

Abort the current transaction

alter_aggregate(7)

Change the definition of an aggregate function

alter_conversion(7)

Change the definition of a conversion

alter_database(7)

Change a database

alter_domain(7)

Change the definition of a domain

alter_function(7)

Change the definition of a function

alter_group(7)

Change role name or membership

alter_index(7)

Change the definition of an index

alter_language(7)

Change the definition of a procedural language

alter_operator(7)

Change the definition of an operator

alter_operator_class(7)

Change the definition of an operator class

alter_role(7)

Change a database role

alter_schema(7)

Change the definition of a schema

alter_sequence(7)

Change the definition of a sequence generator

alter_table(7)

Change the definition of a table

alter_tablespace(7)

Change the definition of a tablespace

alter_trigger(7)

Change the definition of a trigger

alter_type(7)

Change the definition of a type

alter_user(7)

Change a database role

analyze(7)

Collect statistics about a database

begin(7)

Start a transaction block

checkpoint(7)

Force a transaction log checkpoint

close(7)

Close a cursor

cluster(7)

Cluster a table according to an index

comment(7)

Define or change the comment of an object

commit(7)

Commit the current transaction

commit_prepared(7)

Commit a transaction that was earlier prepared for two-phase commit

copy(7)

Copy data between a file and a table

create_aggregate(7)

Define a new aggregate function

create_cast(7)

Define a new cast

create_constraint_trigger(7)

Define a new constraint trigger

create_conversion(7)

Define a new encoding conversion

create_database(7)

Create a new database

create_domain(7)

Define a new domain

create_function(7)

Define a new function

create_group(7)

Define a new database role

create_index(7)

Define a new index

create_language(7)

Define a new procedural language

create_operator(7)

Define a new operator

create_operator_class(7)

Define a new operator class

create_role(7)

Define a new database role

create_rule(7)

Define a new rewrite rule

create_schema(7)

Define a new schema

create_sequence(7)

Define a new sequence generator

create_table(7)

Define a new table

create_table_as(7)

Define a new table from the results of a query

create_tablespace(7)

Define a new tablespace

create_trigger(7)

Define a new trigger

create_type(7)

Define a new data type

create_user(7)

Define a new database role

create_view(7)

Define a new view

deallocate(7)

Deallocate a prepared statement

declare(7)

Define a cursor

delete(7)

Delete rows of a table

drop_aggregate(7)

Remove an aggregate function

drop_cast(7)

Remove a cast

drop_conversion(7)

Remove a conversion

drop_database(7)

Remove a database

drop_domain(7)

Remove a domain

drop_function(7)

Remove a function

drop_group(7)

Remove a database role

drop_index(7)

Remove an index

drop_language(7)

Remove a procedural language

drop_operator(7)

Remove an operator

drop_operator_class(7)

Remove an operator class

drop_role(7)

Remove a database role

drop_rule(7)

Remove a rewrite rule

drop_schema(7)

Remove a schema

drop_sequence(7)

Remove a sequence

drop_table(7)

Remove a table

drop_tablespace(7)

Remove a tablespace

drop_trigger(7)

Remove a trigger

drop_type(7)

Remove a data type

drop_user(7)

Remove a database role

drop_view(7)

Remove a view

end(7)

Commit the current transaction

execute(7)

Execute a prepared statement

explain(7)

Show the execution plan of a statement

fetch(7)

Retrieve rows from a query using a cursor

grant(7)

Define access privileges

insert(7)

Create new rows in a table

listen(7)

Listen for a notification

load(7)

Load or reload a shared library file

lock(7)

Lock a table

move(7)

Position a cursor

notify(7)

Generate a notification

prepare(7)

Prepare a statement for execution

prepare_transaction(7)

Prepare the current transaction for two-phase commit

reindex(7)

Rebuild indexes

release_savepoint(7)

Destroy a previously defined savepoint

reset(7)

Restore the value of a run-time parameter to the default value

revoke(7)

Remove access privileges

rollback(7)

Abort the current transaction

rollback_prepared(7)

Cancel a transaction that was earlier prepared for two-phase commit

rollback_to_savepoint(7)

Roll back to a savepoint

savepoint(7)

Define a new savepoint within the current transaction

select(7)

Retrieve rows from a table or view

select_into(7)

Define a new table from the results of a query

set(7)

Change a run-time parameter

set_constraints(7)

Set constraint checking modes for the current transaction

set_role(7)

Set the current user identifier of the current session

set_session_authorization(7)

Set the session user identifier and the current user identifier of the current session

set_transaction(7)

Set the characteristics of the current transaction

show(7)

Show the value of a run-time parameter

spi_connect(7)

Connect a procedure to the SPI manager

spi_copytuple(7)

Make a copy of a row in the upper executor context

spi_cursor_close(7)

Close a cursor

spi_cursor_fetch(7)

Fetch some rows from a cursor

spi_cursor_find(7)

Find an existing cursor by name

spi_cursor_move(7)

Move a cursor

spi_cursor_open(7)

Set up a cursor using a plan created with SPI_prepare

spi_exec(7)

SPI_exec - execute a read/write command

spi_execp(7)

SPI_execp - execute a plan in read/write mode

spi_execute(7)

Execute a command

spi_execute_plan(7)

Execute a plan prepared by SPI_prepare

spi_finish(7)

Disconnect a procedure from the SPI manager

spi_fname(7)

Determine the column name for the specified column number

spi_fnumber(7)

Determine the column number for the specified column name

spi_freeplan(7)

Free a previously saved plan

spi_freetuple(7)

Free a row allocated in the upper executor context

spi_freetuptable(7)

Free a row set created by SPI_execute or a similar function

spi_getargcount(7)

Return the number of arguments needed by a plan prepared by SPI_prepare

spi_getargtypeid(7)

Return the data type OID for an argument of a plan prepared by SPI_prepare

spi_getbinval(7)

Return the binary value of the specified column

spi_getnspname(7)

Return the namespace of the specified relation

spi_getrelname(7)

Return the name of the specified relation

spi_gettype(7)

Return the data type name of the specified column

spi_gettypeid(7)

Return the data type OID of the specified column

spi_getvalue(7)

Return the string value of the specified column

spi_is_cursor_plan(7)

Return true if a plan prepared by SPI_prepare can be used with SPI_cursor_open

spi_modifytuple(7)

Create a row by replacing selected fields of a given row

spi_palloc(7)

Allocate memory in the upper executor context

spi_pfree(7)

Free memory in the upper executor context

spi_pop(7)

Pop SPI stack to return from recursive SPI usage

spi_prepare(7)

Prepare a plan for a command, without executing it yet

spi_push(7)

Push SPI stack to allow recursive SPI usage

spi_repalloc(7)

Reallocate memory in the upper executor context

spi_returntuple(7)

Prepare to return a tuple as a Datum

spi_saveplan(7)

Save a plan

start_transaction(7)

Start a transaction block

truncate(7)

Empty a table or set of tables

unlisten(7)

Stop listening for a notification

update(7)

Update rows of a table

vacuum(7)

Garbage-collect and optionally analyze a database