sql-info.de

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Index

If you've ever needed a particular sequence of numbers in PostgreSQL, for example for a pivot table, the only way to generate these has been either to create a temporary sequence or to work with a temporary table generated by your application. Beginning with 8.0, PostgreSQL provides the built-in function generate_series(), a set-returning function which can generate any sequence of numbers.

Posted at 2004-11-11 22:08:00

2004-10-29 20:01:00

PostgreSQL | The information schema

Added in PostgreSQL 7.4, the information schema is a facility to provide a standardized description of PostgreSQL metadata: definitions of tables, views etc. The information schema is defined in the SQL standard and should remain stable between PostgreSQL versions (unlike the system catalogues, PostgreSQL's "data dictionary") and should also be compatible with other database systems offering the same feature.

Posted at 2004-10-29 20:01:00

2004-10-28 22:58:00

PostgreSQL | PostgreSQL and Windows

The most visible new feature of PostgreSQL's upcoming 8.0 release is the native Windows version, the first time it has been ported specifically to the Microsoft platform. However, it is only available for the most recent Windows generation, for users of older Windows installation via the Cygwin emulation layer is the only option. The following table provides an overview of which installation options are available for which Windows versions.

Posted at 2004-10-28 22:58:00

Ever start a transaction in psql, then lose track of whether it's been committed or not? psql provides a prompt formatting option (%x) which displays a * whenever a transaction is in process:

Posted at 2004-10-27 21:24:00

Containing mainly bugfixes, localisation commits and more modifications for Windows32. The changelog from Beta 3 is at ftp://ftp.postgresql.org/pub/source/v8.0.0beta/ChangeLog-Beta3-to-Beta4. This is likely to be the last Beta release before the Release Candidates become available.
Posted at 2004-10-26 08:42:00

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Index