The Open Source Swiss Army Knife

/sql_servers/postgresql/
/sql_servers/postgresql/ + sub-categories		 http://www.sirfsup.com/
web directory content
     
      

Not logged in
Chat Register Login
return to:  http:/www.sirfsup.com      /sql_servers   /postgresql 
sub-categories and articles
                                                  
dirpg_contrib add
dirpg_docs postgresql 7.5devel and pg8.0 beta docs
dirpg_hack add
dirpg_i18n add
dirpg_interfaces php c c++ perl interfaces to postgresql server
dirpg_plpgsql add
dirpg_sql postgresql pgsql sample sql
dirpg_triggers writing postgresql triggers tutorial trigger functions before and after trigger
dirpooling add
   --->create new sub-category


pg_administration.htm
user, database, views and sql for db administration

POSTGRESQL ADMINISTRATION

these are all links to other files

pg_alter_postgres_passwd.txt
add

Assuming you still have TRUST authentication setup on the local server, open a psql session as the postgres user (you won't be asked for the password under TRUST authentication) to the database and execute the command: ALTER USER Postgres WITH PASSWORD '';

pg_backup.htm
add


pg_built_in_functions.htm
add

postgres built-in functions

  1. cast( in sql.htm)
  2. lower
  3. concat
  4. extract
  5. sequences
  6. coalesce
  7. regexp_replace
  8. utility functions

pg_create.htm
add

  1. create_database
  2. create_table (see also data_types.htm which has lots of column-specific table constraint commands)
  3. create schema
  4. constraints
  5. create user
  6. create_other
  7. column_types

pg_create_sql.htm
add

  1. create_database
  2. create_table (see also data_types.htm which has lots of column-specific table constraint commands)
  3. create schema
  4. constraints
  5. create user
  6. create_other
  7. column_types

pg_dataWarehouses.txt
descru

data warehousing

  1. R library
  2. pgsql internal library links
  3. R library and Rdbi.pgsql

pg_datatypes.htm
postgres SQL datatypes

column_types

  1. data type storage
  2. serial
  3. arrays
  4. bytea
  5. characters
  6. interval
  7. text data types
    1. --> blob
    2. --> text
  8. number data types
    1. --> smallint: 2 bytes
    2. --> integer: 4 bytes
    3. --> bigint: 8 bytes
    4. --> decimal
    5. --> numeric: 11+(p/2) where p is the first argument before the comma
    6. --> real: these are the float values which can be float, float4 and float8
  9. date
  10. timestamp
  11. oid

pg_encoding.htm
add

  1. https://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/admin_user/multibyte.html
  2. http://www.postgresql.org/docs/7.3/static/multibyte.html

see also create_sql.htm which examples how to create a database which has a certain encoding by default.


pg_hba.conf
add

# PostgreSQL Client Authentication Configuration File # =================================================== # # Refer to the PostgreSQL Administrator's Guide, chapter "Client # Authentication" for a complete description. A short synopsis

pg_indexes.txt
add

xxx=# reindex table xxx; DEBUG: StartTransactionCommand DEBUG: ProcessUtility DEBUG: AbortCurrentTransaction

pg_install.htm
add

postrgresql server

  1. rpm install
  2. cvs install
  3. adduser
  4. create directories
  5. initdb
  6. data layout on your disk
  7. upgrade notes
  8. server's first start and first stop with the pg_ctl client and postmaster
  9. making the first client connections
  10. installing plpgsql server-side SQL

pg_my_config.sh
add

./configure --prefix=/usr/local/pgsql7.4 --with-pgport=1883 --enable-nis

pg_performance.txt
add

performance and query plans

  1. introduction
  2. vacuum and explain select
  3. analyze and explain analyze
  4. filter and index_condition
  5. sample explanation of long query

pg_permissions.htm
pgsql data access permissions users

  1. defaults
  2. create database with owner = somebody
  3. sql.htm#grant: details granting and revoking
  4. users.htm: details user creation
  5. pg_hba.conf
  6. show permissions on a specific database object from psql
  7. ident conf

pg_plpgsql.htm
add

postgres server-side sql

  1. introduction
  2. installing the language
  3. plpgsql function samples in pg/sql source code form
  4. running functions

pg_postgresql_conf.txt
the postgresql.conf file configures the runtime environment (logging, query plans) of the postmaster process

configuring postgresql.conf

  1. debugging params
  2. logging parameters logging parameters
  3. shared buffers

pg_programming.htm
add

  1. intro
  2. c
  3. libpq++

pg_replication.txt
add

replication in postgres ======================= 1. pgreplicator (open source projects) 2. postgres-R (open source project)

pg_schemas.htm
postgres clusters and schema grants

schemas in postgresql

  1. introduction: clusters -> database > schema -> table
  2. create sql for schemas
  3. grant rights on the schemas
  4. setting search_path for each user
  5. revoke usage on schema.... from user
  6. finding all schemas on system

pg_sql.htm
add

sql examples

SQL queries in postgresql are entered to the RDBMS through the psql command line utility, through scripts (php,C,C++).

http://www.postgresql.org/docs/aw_pgsql_book/aw_pgsql_book.sql
  1. alter
  2. case
  3. cast
  4. create user
  5. create table, database, view, schema commands, with column_types explained
  6. copy [to|from]
  7. delete
  8. drop
  9. extract
  10. grant
  11. insert
  12. like
  13. limit
  14. load data
  15. timer
  16. revoke
  17. rollback
  18. select
  19. sequences
  20. update
  21. union

pg_sqldba.htm
add

built-in tables for the dba

These can best be examined using psql -E my_db_name because then it will show which calls are being issued to present the rows from the query, and which query is in fact executing. You will figure it out after you use this cool command, if you really want to know what's happening at the backend.

pg_database
select datname, oid from pg_database;

pg_transactions.htm
add

  1. locks
  2. xlogdump

pg_tsearch.sql
add

CREATE TABLE filenames ( recdate timestamp NOT NULL, season smallint NOT NULL, partno smallint, station text NOT NULL,

pg_users.htm
add

users administaration

  1. alter user
  2. create user
  3. grants and revokes (link to sql.htm#grants)
  4. pgshadow: the system table
  5. show permissions on a specific database object

pg_utilities.htm
utilities for administering postgres database: psql, createdb

  1. .pgpass
  2. initdb
  3. the psql client: connecting to the database from the command line
  4. pg_ctl: starting and stopping
  5. createdb
  6. postmaster
  7. createuser
  8. pgdump
  9. pg_restore

plpgsql.htm
installing and using postgres server-side procedural languages plpgsql

postgres server-side sql

  1. introduction
  2. installing the language
  3. plpgsql function samples in pg/sql source code form
  4. running functions
   --->upload your article


User submitted category site links

strings file December
1. Re: PostgreSQL Indexing versus MySQL
Large Text Skip site navigation Skip site navigation (1) Skip section navigation Skip section navigation (2) Search Peripheral Links Text Size:...
URL: http://archives.postgresql.org/pgsql-general/2004-02/msg00812.php - 15KB - 18 Feb 2004
2. PostgreSQL & PHP Tutorials - Database Joins - Part I [ | | ]
PostgreSQL PHP tutorials
URL: http://www.designmagick.com/article/32/PostgreSQL/Introduction-to-Database-Joins - 13KB - 16 Nov 2008
3. Abort
Practical PostgreSQL PostgreSQL Command Reference PostgreSQL Command Reference ALTER GROUP Practical PostgreSQL Prev Next ABORT Name...
URL: http://www.faqs.org/docs/ppbook/r22770.htm - 4KB - 24 Jun 2003
4. PostgreSQL: Documentation: Manuals: PostgreSQL 8.1: Backup and Restore
Large Text PostgreSQL Home PostgreSQL Search Documentation: Text Size: Normal Text Size Normal / Large Text Size Large Home Home →...
URL: http://www.postgresql.org/docs/8.1/interactive/backup.html - 22KB - 14 Feb 2007
5. 3.2 Tipos Fila (Row)
3.2 Tipos Fila (Row)
URL: http://www.sobl.org/traducciones/postgresql-develdoc/node12.html - 5KB - 28 Mar 2003
6. postgresql.html
No description available.
URL: http://www.solutioninnovators.com/docs/sinotes/postgresql.html - 0KB - 01 Nov 2008
7. 31.html [ | | ]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Status of 7.4 7.4 Release discussion from pgsql-advocacy and pgsql-hackers 18-Jun-2003 At this date, the code...
URL: http://www.varlena.com/varlena/GeneralBits/31.html - 13KB - 19 Feb 2005

-->submit a page from your site dealing with postgresql to the sirfsup! web directory for listing

return to top
24078 [ 483 MB ] of Articles and Code Samples   
5897 pages in the directory #!/bin/sh sys=0; rec=0; for i in `ls *.pagecount`; do sys=$(cat $i); rec=$(( $rec + $sys)); done; echo $rec;
849 Users
Online Since Mar 3 2002
design help and support from mynd4rent design
Don't Worry! The Material on Sirfsup.com is Your Copyright as the Author