PostgreSQL
Database .NET 4.0 released
Database .NET is a simple, uniform and intuitive database management tool for multiple databases, Making Local and Remote Database Administration Easier. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries. A standalone tool that does not require installation. New Features(Ver 4.0) 2010/12/26: Added Index Editor Added IBM DB2 [...]
PostgreSQL 9.1alpha3 Now Available
The third alpha release for PostgreSQL version 9.1, 9.1alpha3, is now available. This alpha release contains several new major features added since the alpha2 release. Please download, install, and test it to give us early feedback on the features being developed for the future versions of PostgreSQL. Features added in 9.1alpha3 since alpha2 include: * [...]
phpPgAdmin 5.0.2 Released
This second update of the pgpPgAdmin 5.0 branch brings some bug fixes on features, compatibility and clean some code. Details bellow. ==== Download ==== To download phpPgAdmin 5.0.2 right now, visit: http://phppgadmin.sourceforge.net/?page=download ==== Changelog ==== * Fix a css typo & error in cappuccino theme * Fix #3139003 “Autocomplete doesn’t insert value”, report and patch [...]
How to Create a New Table in PostgreSQL
You can create a new table by specifying the table name, along with all column names and their types: CREATE TABLE weather ( city varchar(80), temp_lo int, — low temperature temp_hi int, — high temperature prcp real, — precipitation date date ); You can enter this into psql with the line breaks. psql will recognize that the [...]
How to Access a Database in PostgreSQL
Once you have created a database, you can access it by: Running the PostgreSQL interactive terminal program, called psql, which allows you to interactively enter, edit, and execute SQL commands. Using an existing graphical frontend tool like pgAdmin or an office suite with ODBC or JDBC support to create and manipulate a database. These possibilities are not covered in this tutorial. Writing a [...]
How To create a new database in PostgreSQL
The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL server can manage many databases. Typically, a separate database is used for each project or for each user. Possibly, your site administrator has already created a database for your use. He should have told you [...]
What is PostgreSQL?
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later. PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL standard [...]