Hi all,
I have 2 tables:
table1 (field1,field2,.)
table2 (field1,field2,field3,.)
field1 is an uuid type
field2 is a timestamp with time zone type.
If I execute:
explain (analyze on, timing off)
select B.field3,A.field1,A.field2
FROM table1 A INNER JOIN table2 B
using (field1,field2)
Le vendredi 07 juin 2013 à 15:13 +0200, Aitor Gil Martin a écrit :
> How do I convert the bytea content stored in Postgresql into the real file so
> I can put it in a local directory? (and the opposite process: store a file on
> a path to a postgresql database)
> I know this could be more an acce
On Sat, Jun 8, 2013 at 8:06 AM, Enrico Pirozzi wrote:
> Hi all,
>
> I have 2 tables:
>
> table1 (field1,field2,.)
> table2 (field1,field2,field3,.)
>
> field1 is an uuid type
>
Is it a primary key? Is there a foreign key constraint between them?
> field2 is a timestamp with time zone
I changed the hwclock and date/time of the system and synced hwclock with
date/time. hwclock was showing a date around a year ago, which may be due
to some incorrect selection during setup. I will compile again when I will
get access to the server.
I will remember it and will check for other compil
Just for reference, way back in the day my laptop w/486DX50 and 16
megs of RAM took 30 minutes to run ./configure and 1.5 hours to run
make.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-genera
On Sat, Jun 8, 2013 at 12:46 PM, Scott Marlowe wrote:
> Just for reference, way back in the day my laptop w/486DX50 and 16
> megs of RAM took 30 minutes to run ./configure and 1.5 hours to run
> make.
>
Using MinGW and a modern laptop, it does slightly better than that. But
not much.
Just runni
Hi All,
I have a problem with PostgreSQL 8.4. It was working perfectly fine but after
the restart (within a couple of minutes) of my system whenever I login to
PostgreSQL 8.4 (localhost:5432) it gives error as under:
Server doesn't listen
The server doesn't accept connections: the connection l
I need a sample database and hard practice SQL questions (multiple joins,
window functions, subqueries, CTEs) to write ad hoc queries or perform database
tasks. Any suggestions are welcome. Thanks in advance.
Sent from my smartphone
- Reply message -
From: g.si...@utwente.nl
To:
Subjec
On Sun, Jun 9, 2013 at 6:04 AM, wrote:
> Hi All,
>
>
>
> I have a problem with PostgreSQL 8.4. It was working perfectly fine but
> after the restart (within a couple of minutes) of my system whenever I
> login to PostgreSQL 8.4 (localhost:5432) it gives error as under:
>
>
>
> *Server doesn't
