[GENERAL] check for primary key

2009-11-09 Thread Tom Brown
Hey guys! I would like to know how to query for the existence of a primary key on a table. All of the tables have the column 'id' in them. That should be the primary key. However, the primary key constraint got "lost" somehow. Probably due to stupidity on my part. I just want to add back the prim

Re: [GENERAL] inserting 4800 records at a time

2007-03-28 Thread Tom Brown
On Wednesday 28 March 2007 16:43, Dann Corbit wrote: > Link to documentation: > http://www.postgresql.org/docs/8.2/interactive/datatype-geometric.html#A > EN5367 Yep. The polygon type is what I was needing. I tested it out by saving data from nine graphs all at once. That's about 24000 points. Po

[GENERAL] inserting 4800 records at a time

2007-03-28 Thread Tom Brown
Hi, We use an application that generates 4800 points for the graph of a waveform. We capture this data and display it to the user. Now we want to save all this information to a database. I have tried to create a record for each point, but insertion/retrieval is slow. I thought that maybe I coul