Description:
PGSQL Relational Database Management System.
|
|
|
Sequences
|
| |
Hi! Where are stored the sequence information? How I can query the properties of a sequence like increment, max/min value, cache? I'm looking for a table like user_sequences in Oracle, where I can query all of my sequences. Thanks Andre
|
|
|
Control table changes
|
| |
Hello all, I would like to know if it is possible to control changes in the structure of a table... I tried to make a trigger to monitor the updates in the table pg_attribute. Example: when a column is created that table is updated, but the system tables do not accept triggers. :-( Someone would have any suggestions?... more »
|
|
|
Newbie Question: Cannot find pg_config in Debian (lenny) installation
|
| |
Hello c.d.p, I recently installed postgresql under Debian/GNU Linux 5.0 (lenny) using the standard aptitude method. SELECT version(); says: PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.4.2-1.1) 4.3.2 I installed the postgresql8.3 package via metapackage postgresql, postgresql-client-8.3, postgresql-client-common, postgresql-contrib-8.3... more »
|
|
|
doubt on function extract(epoch...)
|
| |
Hi, I read onto documentation: [link] "epoch For date and timestamp values, the number of seconds since 1970-01-01 00:00:00-00 (can be negative); for interval values, the total number of seconds in the interval... more »
|
|
|
vector data
|
| |
Hello! I have to manipulate vector data in an array of 55 dimensions v(measure1, measure2, .... ,measure55) where measureN is an integer. I have about 1 million vectors like that. What is the best way for string and manipulating such data : - a simple table with 55 columns ? - a system like rasdaman ?... more »
|
|
|
merge two big tables
|
| |
I have one table A, which should be updated sometimes. I.e. I download copy of A with some new records. I cannot just drop table A, because there may be records from other sources. What is the best way to do such update? One option could be to create temporary table and do UNION on this two tables. That would append new records without duplicates. Than create... more »
|
|
|
unrecognized headline parameter: "MaxFragments
|
| |
Hello, if i try the following statement: select ts_headline('example text', to_tsquery('example'), 'ShortWord = 3, MinWords = 10, MaxWords = 30, MaxFragments = 2'); i get: ERROR: unrecognized headline parameter: "MaxFragments" Using the option "FragmentDelimiter" i get the error too. I am using the actual version:... more »
|
|
|
dynamic variable interpolation on queries in plpgsql functions
|
| |
Hello, I have a weird question, is there a way to perform a query on a table which the name is been obtaind from another query? A trivial example with no practical purpose invented to show what I mean: create or replace function test(_schema varchar) returns bigint as $$ declare var_table_name record;... more »
|
|
|
Mogwai ER-DesignerNG 1.7-SNAPSHOT available
|
| |
Mogwai ERDesigner NG is a Java based entity releationship design tool. It includes the following key features: * is based on Java and can be run on Windows and Unix systems * has a powerful WYSIWYG for physical database design * handles tables, relations, indexes and comments * supports a central repository for all models ( Model Repository )... more »
|
|
|
