What query can I use to find out the Postgres server version please? Thanks

Walter Hurry

04-08-2013 05:42 AM
M. Strobel

Googler's Matt Cutts G+ https://plus.google.com/+MattCutts/posts *************************** Auslogics System Information ...

Enoch Serin Debif

04-05-2013 08:08 AM
Enoch Serin Debif

In one of my background applications I keep getting a peer communication error stating that a timeout occurred on a connection. The program runs for...

gargoyle60

03-01-2013 07:16 AM
gargoyle60

Hi, how can I execute a function from another database? SELECT * FROM dblink('dbname=mydb user=myself password=pw', 'SELECT fc_b_zone(12, 4711)')...

Stefan Wirrer

02-20-2013 06:01 AM
Stefan Wirrer

Hi I need to get a list of pgsql data types like the one when you create a new function. I tried to look in the pg_catalog but to no...

ivan.sammut@credorax.com

02-13-2013 11:54 AM
Harry Tuttle

Hi ppl, I have a function which returns a number of transactions which fall between 2 dates and when I run this in a normal query window it is quite...

ivan.sammut@credorax.com

01-15-2013 01:39 AM
Jasen Betts

Hey all, I am a little rusty on my SQL and Database design. I've been working to get a basic appplication back up and running, but I've run into...

Aaron W. Hsu

01-13-2013 01:04 AM
Jasen Betts

Hi Guys, I have billions of tree like records in PostgreSQL 9.2 database on RHEL 5 X64, what is the best way to do the query in PostgreSQL, like :...

Ziliang Chen

11-23-2012 07:47 AM
Ziliang Chen

Hello, our current problem is, how to forbid the use of short and/or weak passwords ("abc123", "password", "1234", ...) by our users and we...

Andreas Kunert

11-06-2012 06:29 AM
Andreas Kunert

We just started to use PostgreSQL. For new table entries (type TEXT) we find line breaks represented as \r\n (the Windows convention), wich is OK...

Franz Kruse

11-01-2012 04:37 PM
Robert Klemme

I am considering various approaches to data backup on single-user standalone desktop Windows (XP) file system and was wondering if it is safe to...

gargoyle60

10-22-2012 03:39 AM
gargoyle60

Hi, the psql docs say that a perl trigger can return one of the following: return; Execute the statement "SKIP" Don't execute the...

Marky Mark

09-26-2012 03:05 AM
M. Strobel

Hi, I am pleased to announce the release of ODB 2.1.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to...

Boris Kolpackov

09-18-2012 07:25 AM
Boris Kolpackov

Hi there, I want to use a database for storing economic time series. An economic time series can be thought of as something like this: NAME ...

st.helldiver@googlemail.com

09-04-2012 03:29 PM
st.helldiver@googlemail.com

I am using postgresql 8.1.3 on redhat, and trying to use partitioned tables to manage a multi-terabyte table. I've created the parent table and the...

Greg Hennessy

08-17-2012 07:30 PM
Jasen Betts

I'm using postgresql 8.1.23 on a redhat 5 machine. I have some tables that have a schema of: PS1=# \d tmp_00 Table "public.tmp_00" Column | Type...

Greg Hennessy

08-15-2012 07:59 AM
Greg Hennessy

Hi, I am a beginner with pgadmin (version 1.14.3). I would like to make a local DB on my computer. But I do not manage to connect to serveur, I...

Vulcain

08-15-2012 05:07 AM
Vulcain

I have a rather large table (3 TB) that I need to split up. I can do a bunch of select yada into tmp_00 from centroids where value=0; select yada...

Greg Hennessy

07-22-2012 05:57 PM
Greg Hennessy

Hi to all, my mac book pro died and I recover my pg folder from the old HD. Now under Imac I've tried to recover data replacing my data folder under...

pyarchinit@gmail.com

07-21-2012 06:37 AM
Jasen Betts

China Blue , Meersburg <chine.bleu (AT) yahoo (DOT) com> wrote: You have to mark the beginning and the end of the code, usually...

Lennart Jonsson

07-10-2012 08:55 AM
Matthew Woodcraft

anyone doing this? all logic in tables n db and html templated in the db?

quiet_lad

07-02-2012 07:09 PM
quiet_lad

Hi, I have a custom base type that relies heavily on caching for many of the functions derived from those values. I'm looking for suggestions as to...

Don Y

06-28-2012 01:06 PM
Don Y

I've got a composite field: CREATE TYPE my_type AS ( part1 varchar, part2, varchar ); and I'm going a db conversion that is taking an existing...

Steve Rogerson

06-28-2012 07:09 AM
Jasen Betts

Hi I know postgresql but not enough to solve the following problem: Here is a table with the fields: name char(20), c1 char(1), c2 char (1) The...

meta

06-22-2012 04:46 PM
meta

Can you please help with advice? I need to design a solution for a database which will grow and will requirea horizontal split at some moment. Here...

igor.shmain@gmail.com

06-04-2012 06:17 PM
Mladen Gogala

Hi, I have a question about using SQL to check the missing values of over 400 fields. I really don't want to run a select sentence for each field. I...

Kenneth Zhang

05-25-2012 01:31 PM
Kenneth Zhang

I am pleased to announce the release of ODB 2.0.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist...

Boris Kolpackov

05-02-2012 07:35 AM
Boris Kolpackov

Hi, I'm stuck with a (maybe simple) problem of JOINing two tables.. The thing is that I need to join these tables on two different columns. Let's...

Mateusz

04-12-2012 01:38 PM
Robert Klemme

Hi all, I'm just wondering, what is the equivalent of the Oracle Wait Interface (i.e. the V$<View_Name> system) in PostgreSQL? TIA and...

Pol

03-22-2012 11:04 PM
Mladen Gogala

Le 15/03/2012 02:25, Mladen Gogala a écrit : Good morning, Sorry about my french explanation. There was no old news in my reader and i have...

bcar

03-16-2012 04:49 AM
Jasen Betts

Having the choice is a good thing, but I wouldn't want to use a DBMS that is so crippled when it comes to SQL features as MySQL (CTE, recursive...

Mladen Gogala

02-18-2012 03:07 PM
Hans Castorp

Hi, While in() and out() routines are required for a type, recv() and send() are "optional". Could someone clarify when recv/send are used in...

Don Y

02-14-2012 11:57 PM
Don Y

Hi, I have a few types that aren't economically supported in PostgreSQL that I'll be implementing as "user-defined types" (NOT "composite types"). ...

Don Y

02-14-2012 09:53 PM
Don Y

Just installed it to my Windows 7. (During installation it alerted about fatal error but it completed anyway), it has a NT service but failed to...

justaguy

02-14-2012 11:50 AM
Mladen Gogala

Hi, In my project I changed all timestamp columns to timestamp with time zone. I am used to test a lot using psql. Now the display of...

M. Strobel

02-10-2012 02:56 AM
Marcos PPa PPe

Hi, For "non-standard" types (e.g., composite, user-defined), is there any way of teasing the definition out of the system catalog? E.g., CREATE...

Don Y

02-08-2012 02:18 AM
Don Y

I use to_char(real_value, 'FM999.9') to cut off the 2nd and subsequent decimals. Is there a way to format the above output so that negative...

Bjarne Jensen

01-23-2012 02:17 PM
Bjarne Jensen

Hello, We gave a Postgres 8.4 database running under Linux Centos 5.4 and defined so : ENCODING = 'SQL_ASCII' TABLESPACE = pg_default LC_COLLATE =...

Alain Reymond

01-19-2012 04:34 AM
Fredrik Jonson

Hi, I am pleased to announce the release of ODB 1.7.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to...

Boris Kolpackov

12-07-2011 04:48 AM
Boris Kolpackov

On Nov 25, 7:54*pm, Matt <hfr... (AT) syrius (DOT) org.invalid> wrote: Thanks for the idea of postgresql, bad experience. It took 10+ minutes to...

justaguy

12-02-2011 02:40 AM
Laurenz Albe

Hi, I'm installing postgresql (9.1) to my Windows 7, half way through my system prompted me for permission to allow bcdedit.exe or not? What's this...

justaguy

11-28-2011 02:48 AM
Laurenz Albe

Hi @ all, When I do a "SELECT * FROM myTable WHERE ..." using psql I want to have the columns displayed in a meaningful order by default. I want to...

Michael Hufschmidt

11-04-2011 12:29 PM
Matthew Woodcraft

Hi! I continue the old theme what is named "When the session ends": http://archives.postgresql.org/pgsql-general/2011-06/msg00913.php I want to...

durumdara

11-03-2011 06:34 AM
durumdara

Hi, Given largely static tables (etc.), how much of ./data can I move onto R/O media? And, which types of operations would a user then have to...

Don Y

10-25-2011 05:37 AM
Laurenz Albe

Hi, I am pleased to announce the release of ODB 1.6.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to...

Boris Kolpackov

10-04-2011 06:47 AM
Boris Kolpackov

Yeah, they do. I'm most of the way through repairing a 57G table which takes about a day and a half. Hmmn. This suggests that you might want to...

Ignoramus5263

09-23-2011 06:01 AM
Bodo

Hi, I just can not find the set based sql approach to the following application logic: I have a table of choices with id and text, say: 1 coffee 2...

M. Strobel

09-10-2011 05:30 AM
M. Strobel

I'm using Postgres and the end-users are complaining that the search features provided by the web app are case-sensitive (via Postgres). Is there a...

RVince

09-05-2011 09:21 PM
Mladen Gogala

I get a "new" database every 4 weeks. They all have the same schema. I need to find out what changes were done to certain tables from one issue to...

Bjarne Jensen

08-29-2011 01:48 AM
Bjarne Jensen

Hi folks, I am trying to make regular ERD's of a changing PostgreSQL DB available to developers at my organization. Two questions: 1. Is there a...

Elisa

08-22-2011 04:09 PM
Username