Extensive documentation - YarentY

cuttlefishblueΔιαχείριση Δεδομένων

16 Δεκ 2012 (πριν από 4 χρόνια και 4 μήνες)

148 εμφανίσεις

pgAdmin
Written by yarenty
Monday, 12 April 2004 09:54 - Last Updated Monday, 21 July 2008 15:56
pgAdmin III is the most popular and feature rich Open Source administration and development
platform for
PostgreSQL
, the most advanced Open Source database in the world. The
application may be used on Linux, FreeBSD, OpenSUSE, Solaris, Mac OSX and Windows
platforms to manage PostgreSQL 7.3 and above running on any platform, as well as
commercial and derived versions of PostgreSQL such as
Enterprise
DB
,
Mam
moth PostgreSQL
,
Bizgres
and
Greenplum database
.

pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to
developing complex databases. The graphical interface supports all PostgreSQL features and
makes administration easy. The application also includes a syntax highlighting SQL editor, a
server-side code editor, an SQL/batch/shell job scheduling agent, support for the
Slony-I
replication engine and much more. Server connection may be made using TCP/IP or Unix
Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional
drivers are required to communicate with the database server.

pgAdmin III is developed by a community of PostgreSQL experts around the world and is
available in more than a dozen languages. It is Free Software released under the
Artistic
License
.
 
 
 pgAdmin has a huge array of features and by far the best way to see them all is to
download
a
copy and give it a try. Here's a brief list to give you an idea of it's capabilities:
1 / 4
pgAdmin
Written by yarenty
Monday, 12 April 2004 09:54 - Last Updated Monday, 21 July 2008 15:56
Multiplatform
-
Microsoft Windows ™ 2000 and above
-
Linux
-
FreeBSD
-
Mac OSX
-
OpenBSD
-
Solaris
Designed for multiple PostgreSQL versions and derivatives
-
PostgreSQL 7.3 and above
-
EnterpriseDB
-
Mammoth PostgreSQL
-
Greenplum Database
Extensive documentation
-
pgAdmin Documentation
-
Guru Hints to help less experienced users
-
PostgreSQL documentation (on-line and off-line)
-
Slony-I documentation
 GOOGLEME
 
Multilingual interface
-
Over a dozen supported translations and over 25 partial translations. A detailed list of
supported languages is available on the
translation status
page.

Data access
-
Native PostgreSQL acccess (no ODBC layer needed)
-
Powerful query tool with colour syntax highlighting
-
Very fast datagrid for display/entry of data

Routine maintenance
-
Configuration file editing
2 / 4
pgAdmin
Written by yarenty
Monday, 12 April 2004 09:54 - Last Updated Monday, 21 July 2008 15:56
-
Auto-vacuum management (PostgreSQL 8.1 and above)
-
Logfile browser
-
Lock viewer
-
Server status/process viewer
-
SQL/shell/batch job scheduling agent

Access to all PostgreSQL objects
Objects are displayed with their SQL definition, and a user friendly list of properties. Dependent,
and dependency objects may also be browsed, and object statistics viewed where appropriate.
-
Aggregates
-
Casts
-
Columns
-
Constraints
-
Conversions
-
Databases
-
Domains
-
Functions
-
Groups
-
Indexes
-
Operator classes
-
Operators
-
PostgreSQL servers
-
Roles
-
Rules
-
Schemas
-
Sequences
-
Server-side languages (such as pl/pgsql, pl/perl, pl/python, etc.)
-
Slony-I objects (such as nodes, clusters etc.)
-
Tables
-
Tablespaces
-
Trigger functions
-
Types
-
Users
-
Views

Multibyte support
pgAdmin III supports most PostgreSQL server-side encodings:
3 / 4
pgAdmin
Written by yarenty
Monday, 12 April 2004 09:54 - Last Updated Monday, 21 July 2008 15:56
-
SQL_ASCII
-
EUC_JP, EUC_CN, EUC_KR, EUC_TW
-
JOHAB
-
LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10
-
ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8
-
UNICODE/UTF-8
-
MULE_INTERNAL
-
KOI8
-
WIN
-
ALT
-
WIN1256
-
TCVN
-
WIN874
 
 
4 / 4