PostgreSQL

Скачать в pdf «PostgreSQL»


Description


ereatelang is a utility for adding a new programming language to a Postgres database. ereatelang eurrently aeeepts two languages, plsql and pltel.


Although baekend programming languages ean be added direetly using several SQL eommands, it is reeommended to use ereatelang beeause it performs a number of eheeks and is mueh easier to use. See CREATE LANGUAGE for more.


Notes


Use droptang to remove a language.


Usage


To install pitch


$ ereatelang pltel

D.29 ereateuser


Name


createuser — Create a new Postgres user createuser [ options ] [ username ]


Inputs


■h, -host host Specifies the hostname of the machine on which the postmaster is running.


-p, -port port Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the postmaster is listening for connections.


-e, -echo Echo the queries that createdb generates and sends to the backend.


-q, -quiet Do not display a response.


-d, -createdb Allows the new user to create databases.


-D, -no-createdb Forbids the new user to create databases.


-a, -adduser Allows the new user to create other users.


-A, -no-adduser Forbids the new user to create other users.


-P -pwprompt If given, createuser will issue a prompt for the password of the new user. This is not necessary if you do not plan on using password authentication.


-i, -sysid uid Allows you to pick a non-default user id for the new user. This is not necessary, but some people like it.

Скачать в pdf «PostgreSQL»