PG Lightning Admin
Contents
| Index
- $ -
$
$BODY$
$libdir
- * -
*
- . -
.pgpass
- A -
ABORT
abs
accumulate
ACL
Add
Add a server
Aggregate Editor
aggregate function
built-in
invocation
user-defined
alias
for table name in query
in the FROM clause
in the select list
ALL
alpha blending
ALTER AGGREGATE
ALTER CONVERSION
ALTER DATABASE
ALTER DOMAIN
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER OPERATOR
ALTER OPERATOR CLASS
ALTER ROLE
ALTER SCHEMA
ALTER SEQUENCE
ALTER TABLE
ALTER TABLESPACE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ANALYZE
AND (operator)
ANY
anyarray
anyelement
area
array
constant
constructor
determination of result type
of user-defined type
Asynchronous Notification
autocommit
bulk-loading data
auto-increment
autovacuum
general information
global configuration parameters
table-specific configuration
average
- B -
backup
base type
BEGIN
BETWEEN
BETWEEN SYMETRIC
bigint
bigserial
binary data
bison
bit string
constant
data type
bit strings
functions
bit_and
bit_length
bit_or
bitmap scan
BLOB
Bookmark
bookmarks
bool_and
bool_or
Boolean
data type
operators
booting
starting the server during
box (data type)
B-tree
bug tracking
builder
bytea
in libpq
- C -
C
cancel
canceled
canceling
SQL command
Capture
CASCADE
foreign key action
with DROP
CASE
determination of result type
case sensitivity
of SQL commands
center
char_length
character set
character string
constant
check constraint
CHECKPOINT
cid
cidr
circle
client authentication
clipboard
CLOSE
close button
close options
closed
CLUSTER
of databases
clusterdb
cmax
cmin
COALESCE
Code
code completion
Code completion
column
adding
removing
renaming
system column
column data type
changing
column reference
columns
command line
COMMENT
in SQL
COMMIT
COMMIT PREPARED
common fields
comparison
operators
row-wise
subquery result row
compiling
libpq applications
Completion
composite type
constant
constructor
computed field
concurrency
conditional expression
configuration
functions
of the server
configure
conjunction
connections
constant
constraint
adding
check
foreign key
name
NOT NULL
primary key
removing
unique
constraint exclusion
context
CONTINUE
in PL/pgSQL
convert
COPY
with libpq
count
Create a Function
Create a new database
Create a table
CREATE AGGREGATE
CREATE CAST
CREATE CONSTRAINT
CREATE CONVERSION
CREATE DATABASE
CREATE DOMAIN
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
createdb
createlang
createuser
crypt
cstring
CTID
CTRL+E
CTRL+ENTER
currval
cursor
CLOSE
DECLARE
FETCH
in PL/pgSQL
MOVE
showing the query plan
- D -
data area
data type
base
category
composite
constant
conversion
internal organization
numeric
type cast
user-defined
database
creating
privilege to create
database activity
monitoring
database cluster
DBI
DDL
deadlock
DEALLOCATE
decimal
DECLARE
default value
changing
DELETE
deleting
Dependency
Dependency Viewer
diameter
dirty read
disjunction
disk drive
disk space
disk usage
DISTINCT
dollar quoting
Domain Editor
double precision
Drop
DROP AGGREGATE
DROP CAST
DROP CONVERSION
DROP DATABASE
DROP DOMAIN
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP OPERATOR
DROP OPERATOR CLASS
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP TABLE
DROP TABLESPACE
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
dropdb
droplang
dropuser
duplicate
duplicates
dynamic loading
dynamic_library_path
- E -
ecpg
Editor
elog
in PL/Python
embedded SQL
in C
encryption
END
Enterprise Manager
Environment Options
environment variable
ereport
error codes
list of
error dialog
Error Handling
error message
escaping strings
every
EXCEPT
exceptions
in PL/PgSQL
EXECUTE
EXISTS
EXIT
in PL/pgSQL
EXPLAIN
Exporting
expression
order of evaluation
syntax
extending SQL
extensions
- F -
false
FAQ-Liste
fast path
Features
FETCH
field
computed
field selection
filter
filtered
flex
float4
float8
floating point
foreign key
formatting
free space map
FreeBSD
start script
fully qualified domain name
function
in C
in SQL
in the FROM clause
internal
invocation
output parameter
polymorphic
type resolution in an invocation
user-defined
Function Editor
- G -
General
generate_series
generator
GiST
global data
in PL/Python
in PL/Tcl
Goto
Goto Error Context
GRANT
Grant Manager
GREATEST
determination of result type
Grids
Group
GROUP BY
grouping
groups
- H -
has_database_privilege
has_function_privilege
has_language_privilege
has_schema_privilege
has_table_privilege
has_tablespace_privilege
hash
HAVING
height
Hides
hierarchical database
history
of PostgreSQL
host name
- I -
ident
identifier
length
syntax of
IFNULL
IMMUTABLE
Importing
IN
index
B-tree
combining multiple indexes
examining usage
for user-defined data type
GiST
hash
locks
multicolumn
on expressions
partial
R-tree
unique
inet (data type)
inet_client_addr
inet_client_port
inet_server_addr
inet_server_port
information schema
inheritance
initdb
INOUT
input function
of a data type
INSERT
insert statement
inserting
installation
on Windows
instr
int2
int4
int8
integer
interfaces
internal
INTERSECT
invoked
IP address
ipcclean
IS DISTINCT FROM
IS FALSE
IS NOT FALSE
IS NOT NULL
IS NOT TRUE
IS NOT UNKNOWN
IS NULL
IS TRUE
IS UNKNOWN
isclosed
ISNULL
isopen
- J -
join
controlling the order
natural
outer
self
- K -
Kerberos
key word
list of
syntax of
- L -
label
language
language_handler
large object
lastval
ldconfig
LEAST
determination of result type
length
libperl
libpq
libpq-fe.h
libpq-int.h
libpython
LIKE
and locales
LIMIT
line segment
Linux
start script
LISTEN
lo_close
lo_creat
lo_create
lo_export
lo_import
lo_lseek
lo_open
lo_read
lo_tell
lo_unlink
lo_write
LOAD
locale
LOCK
monitoring
login privilege
long running query
loop
in PL/pgSQL
lower
and locales
lseg
- M -
MAC address
macaddr (data type)
Main Tool Bar
maintenance
make
MANPATH
max
maximize
MD5
MDI
MDI editors
memory
memory context
in SPI
Menu/Toolbar Shortcuts
messages
messages tab
min
minimize
monitor
monitoring
database activity
MOVE
MS Access
multiple rows
MVCC
- N -
name
qualified
syntax of
unqualified
natural join
navigator
negation
NetBSD
start script
network
data types
NEXT
nextval
nonblocking connection
nonrepeatable read
NOT (operator)
NOT IN
notice
Notice
notice processing
in libpq
notice processor
notice receiver
NOTIFY
in libpq
NOTNULL
not-null constraint
npoints
NT 4.x
null value
comparing
default value
in DISTINCT
in PL/Perl
in PL/Python
with check constraints
with unique constraints
NULLIF
number
constant
numeric
numeric (data type)
NVL
- O -
object identifier
data type
object-oriented database
octet_length
OFFSET
OID
column
in libpq
on-line backup
ONLY
opaque
OpenBSD
start script
operator
invocation
logical
precedence
syntax
type resolution in an invocation
user-defined
operator class
Options
OR (operator)
Oracle
porting from PL/SQL to PL/pgSQL
ORDER BY
