Logo Knowledge Base
Search Books Log in
PostgreSQL
database
Book Navigation
  • Programming and Web Development

  • PHP

    • How do I update root certificates in Apache/PHP/cURL environment

    • What are the differences between addslashes(), mysql_escape_string() and mysql_real_escape_string()

    • PHP and ODBC

    • Speed of unpack() in PHP

    • Configuring PEAR on Windows

    • How do I use cURL in PHP on Windows?

    • Passing command-line arguments into PHP

    • Using SSL socket in PHP under Windows

    • PHP Resources

    • PHP error reporting

    • PHPXref vs PHPDocumentor

    • Create a PHP unit test case using SimpleTest

    • PHP Commenting Style

    • phpMyAdmin Security

    • PHP

    • How can I make phpMyAdmin avoid sending MySQL passwords in the clear?

    • PHP ODBC Setup Guide

    • Performance of array_shift and array_pop in PHP

  • JavaScript

    • Javascript

    • Numeric Validation JavaScript

    • The advantages of Javascript

    • jQuery Tutorial

    • Which Javascript framework should I use?

    • jQuery and JavaScript Coding: Examples and Best Practices

  • Java

    • Java

    • XML and Java

    • Converting Java content into AJAX (Javascript and XML)

    • Create a Java class that is only comparable to itself

    • Removing old Java versions

    • Java Server Faces

  • SQL

    • MySQL Resources

    • PostgreSQL Resources

    • Why doesn't mysqlshow work for databases or tables with underscores in their names?

    • What is mysqlshow good for?

    • How can I search/replace strings in MySQL?

    • Microsoft Access, OpenOffice and MySQL

    • SQL joins

    • Get rid of default annoyances in MySQL Workbench

    • Who uses PostgreSQL at UCLA?

    • Why NoSQL Matters

  • Git and Version Control

    • Subversion

    • Revision Control

    • Revision Control Systems Compared

    • Installing Subversion on Windows

    • GIT info

    • What are some document management services/document version control applications out there?

    • svn: Working copy '<filename>' is missing or not locked

  • My webserver has died! How do I bring it back online in a hurry?

  • CSS and Web Design

    • Learning about CSS

    • What sort of menus can I make with CSS?

    • Top Ten Web Design Mistakes of 2005

    • The importance of "!important" in CSS

    • CSS Design Concerns for IE6, IE7, and Firefox

    • Forcing a page break with CSS

    • What's a solid starting point (global reset) for a CSS file?

    • UX Team ( UCLA Library - Digital Initiatives & Information Technology )

    • Hi, are there any UCLA style resources or style guides for websites?

    • UX Resources

    • What to do when CSS stylesheets refuse to apply

    • Web Accessibility Resources

    • Sass versus LESS

  • XML

    • Introduction to XML in Flash - Making Flash Dynamic

    • XML Resources

    • XML

  • Plone

    • Why is it important to use short names in Plone?

    • Plone CMS Resources

    • Plone 4 Tips and Tricks: Table of Contents

    • How do I identify the stylesheets in Plone?

    • How to get rid of icons in Plone

    • Importing and exporting a Plone site

    • Installing Plone v3.2 on Mac OS X 10.5

    • Remove highlighting of search terms in Plone

    • Is there a permission that allows a user edit content that s/he does not own in Plone?

    • Why can't I add a photo using AT Photo in Plone?

    • Shibboleth For Plone

    • How do I get started with designing new/existing layouts in Plone?

    • Backing up and packing Plone's database file (Data.fs)

    • Zope/Plone usage statistics

    • Should I use plonecustom.css when changing the layout for my Plone site

    • Changing number of displayed news/events in Plone portlets

    • Search across multiple Plone instances

    • How can I undo changes in Plone?

    • How do I remove the icons in Plone?

    • How do I change the header image in Plone?

    • Why are my excluded Plone items still showing up in navigation?

    • Plone and Zope Screencasts

    • How to add new slots in Plone

    • Restricting Plone portlets to show up only on certain pages

    • Can Plone display content from another site inside it?

    • How can a rotating banner image be done in Plone?

    • How do I make dynamic dropdown/pullup menus in Plone?

    • How do I enable the advanced mode of the TinyMCE editor for Plone?

    • Why aren't my font colors / scripts / Flash / Java applets showing up in my Plone site?

    • Importing existing HTML content into Plone

    • How do you enable short names in Plone?

    • Plone 4 Tips and Tricks

  • Shibboleth

    • Why does Shibboleth sometimes return different names for students than class roster?

    • Will Shibboleth say this is a UCLA person, so that we can limit some content to just UCLA?

    • Shibboleth Apache Multiple Virtual Host Configuration (using Moodle as an example)

    • Campus Resources for Registrar Data, ISIS, Shibboleth

    • IAMUCLA Shibboleth Set-Up Guides

    • Is it possible to set up a survey using Shibboleth logins?

    • Shibboleth

    • Can Shibboleth log all attributes retrieved?

  • Lucene

    • Lucene spans

    • Lucene term documents and term positions

    • Pure negation query in lucene

    • Why are Lucene's stored fields so slow to access

    • Lucene

    • Compiling Lucene with GCJ

  • Apache log shell scripts

  • What is Ajax web programming?

  • Programming articles to read

  • What is AOL Server and ACS?

  • ColdFusion

  • Python Resources

  • .NET Programming

  • What is Haskell?

  • What is HTML and how can I learn it?

  • Mapping Resources

  • Perl resources

  • Programming Securely

  • WSRP

  • XML and Python

  • I am trying to develop an application using AJAX. Where do I find out more information?

  • What are Favelets / How can I modify my browser on the fly?

  • Why URLs shouldn't change

  • How to get rounded corners on web pages

  • a:visited property not working in Firefox, but working in IE

  • The Document Object Model (DOM) and what it's good for

  • Setting REMOTE_USER Apache variable in scripts

  • What are Microformats?

  • What are some tips for making solid web forms?

  • Technical Cheat Sheets

  • How to prevent "hotlinking" of your images on a web site

  • How do I find what Perl modules are installed on my system?

  • In a web application, how can I flash an image after a user presses a button?

  • CAPTCHA alternatives

  • How to find broken links in your web site

  • How can I get standard cross browser font-sizes?

  • What's an easy way to set up a WAMP test environment?

  • On a UNIX / Linux system, how do I view which shared libraries a program needs?

  • Security Testing your Apache Configuration with Nikto

  • How do I easily install the software for a LAMP server

  • SPML

  • pubcookie

  • IMS

  • Hibernate

  • eduPerson

  • How do I count the number of times a word or phrase occurs in a string?

  • Django

  • How do I use Perl to create an animated gif from a large number of images?

  • How do I force an image to reload on a web page?

  • Web Development Standards - Best Practices

  • Including sites in main UCLA search engine

  • One-stop Ruby on Rails packages

  • url

  • SSL Configuration Generator

  • iOS Programming

  • Apache 2 Virtual Hosts File

  • How to provide your own customized WAYF page

  • Building an OpenSocial Gadget with GWT and Hosting on Your Website

  • Calling makeRequest in GWT to Get External Data for an Opensocial Gadget and Creating an Overlay

  • Passing Parameters to an OpenSocial Gadget Hosted in Regular HTML

  • Has anyone tried CouchDB?

  • "Requested URL not found" when using Apache with mod_alias and mod_rewrite

  • Suspendable Requests for LAMP systems?

  • Debugging Web Applications with Selenium

  • ENVI 4.6 and 4.6.1 Java problems

  • ENVI 4.6 or 4.6.1 Help does not work

  • Mobile Web Resources

  • Provisioning and Managing Windows Clients

  • Do you know of anyone at UCLA using Drupal right now?

  • Scope of environment variables in shells and shell scripts

  • Free/open source information retrieval libraries

  • How to create a Python class from a SOAP WSDL

  • Passing command-line argument into a DOS (including Windows) batch file

  • Google Sitemap Generator

  • Code Beautifiers And Formatters

  • Configuring MediaWiki to Search for Three Letter Words

  • Configuring Short URLs in MediaWiki

  • csh and single quotes

  • Python and SOAP

  • What is SQLAlchemy

  • About IAMUCLA

  • shrinking text

  • Google Chart API

  • Simplifying web-based processes with CoScripter

  • Manual setting of filename and type in a dynamically-generated web page

  • What characters can go into a valid HTTP URL?

  • Find Google Stats about your website

  • Google Font API

  • Setting up XAMPP for email feature development

  • Sass Variables for UCLA Color Palette

  • Steps for Cloning a Repository in SourceTree

  • web scraping tools

  • Mac OS X - Local Web Development Environment Setup

  • robots.txt

  • Cross Browser Testing

  • has anyone tried wolfram programming cloud?

  • ELK Stack

  • Top Programming Languages

  • How to Easily Recognize Web Colors from RGB Codes

  • DevOps Resources

  • Microsoft Test Lab Guides

  • Regular Expressions

  • Regular expression use cases

  • Microsoft VHD Test Drive Program

  • html entity conversion website

  • Google Code Playground

  • Is There Such a Thing as Free Software? The Pros and Cons of Open-Source Software

  • Authentication via Proxy

  • Intel chipset (BIOS) RAID migration

  • SSL Certificate and Subject Alternative Names (SAN)

  • Cloud Computing

  • Accessibility Demonstration Videos

  • Find Peak Hours of Your Websites with Google Analytics

  • In-Common SSL Cert Installation on Apache 2.2

  • Migrate to a virtual Linux environment with Clonezilla

  • Alternatives to Google Analytics

  • Stanford Self-Help Web Design Resources

  • User Testing Tools

  • Deploying FileVault2

  • How to make a Favicon.ico

  • What kind of test can SimpleTest do?

  • Web Services

  • Eclipse

  • Web Developer and Designer Resources

  • Who is using Ruby on Rails at UCLA?

  • Web Services Resources for Programmers

  • Where can I find other programmers at UCLA?

  • What is your favorite techie interview question?

  • As a UCLA programmer, where do I get data about electronic reserves?

  • JSR223 Scripting Pages in Java Web Applications

  • Ruby on Rails Resources

  • OpenACS (Open Community Architecture System)

  • SAML

  • SOAP

  • WebDAV

  • WSDL

  • Usability Testing

  • REBOL Resources

  • XACML

  • What is code generation?

  • What can I use to do load testing or functional testing of my web server?

  • What is Identity 2.0 and as a web developer, why do I care?

  • Does UCLA have free access to O'Reilly and Associates programming books online?

  • Where can I find free web programming tutorials and sample code?

Books
Programming and Web De...
SQL
PostgreSQL Resources

PostgreSQL Resources

See Also:

  • Who uses PostgreSQL at UCLA?

PostgreSQL official website:

  • http://www.postgresql.org

Modified versions:

  • Bizgres
  • ExtenDB

Tuning Guides:

  • PostgreSQL 8.0 Performance Checklist
  • How the Planner Uses Statistics
  • Server configuration options

Graphical Admin Tools:

  • pgAdmin
  • Aqua Data Studio
  • EMS SQL Manager for PostgreSQL

Web-based Admin Tools:

  • phpPgAdmin
Details
Revision #5
Created 18 years ago by Fong, Jason
Updated 13 years ago by Franks, Mike
Actions

Export
  • Contained Web File .html
  • PDF File .pdf
  • Plain Text File .txt
Back to top