[SQL] Simultaneous Connection Problem

t yet. Thanks, -- Webb Sprague Programmer O1 Communications

[SQL] Getting number of days

Hi All, Does anybody know how to convert an interval into a number of days. Say I have something like '2 years 4 months 4 ago', I need to get the total number of days, something like 800 (ish). Is there a built in function? Thanks W __ Do You Ya

[SQL] Convert from Seconds-Since-Epoch to Timestamp

Hi all, How do I convert from seconds (an integer) to timestamp? I am sure it is easy, but I can't find it in the docs, so far. Thanks Webb __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

Re: [SQL] Optimizing huge inserts/copy's

I am experimenting with this too. If I have any indexes at all, the copy's get VERY SLOW as the table gets big. Delete ALL your indexes, do your copy's, and then create your indexes again. Good luck. --- Jie Liang <[EMAIL PROTECTED]> wrote: > Hi, there, > > I tried different ways, include va

Re: [SQL] Create Primary Key + Massive Copy's?

However, if you have the columns > as NOT NULL already, adding a unique index to the > columns in question has the same general effect. > > Stephan Szabo > [EMAIL PROTECTED] > > On Tue, 29 Aug 2000, Webb Sprague wrote: > > > Apropos of my last question: > > > &

[SQL] Create Primary Key?

Apropos of my last question: Is there syntax to create a primary key after the table has been defined and populated? I think I could speed things up quite a bit by not having any indexes at all when I do my mass copies. Thanks, and my apologies if that is a totally stupid question. W

[SQL] Optimizing huge inserts/copy's

Hi all, Does anybody have any thoughts on optimizing a huge insert, involving something like 3 million records all at once? Should I drop my indices before doing the copy, and then create them after? I keep a tab-delimited file as a buffer, copy it, then do it again about 400 times. Each separ

Re: [SQL] Re: Argument variables for select

I think you have to run "createlang pltcl db-foo" from the command line. As for your boss, here are three things I can think of off the top of my head: 1. All new products take some time to learn. If you can't use Postgres perfectly in a week or so, remember that you probably can't learn to b

Re: [SQL] Best way to create DML/DDL log?

I think there is either a switch to the psql client or a "\" command in the session that allows you to log to a file. Even if you have to do some redirection, it seems a lot better than modifying postgres.c (though I am quite impressed that you would think about it...) --- "Ingram, Bryan" <[EMAI

Re: [SQL] Continuous inserts...

Hi All. Shouldn't Postgres block while vacuuming, and then continue inserting starting where it left off? Is the time lag too much? I am curious because I am going to build a similar app soon, basically parsing and inserting log file entries. W --- Stephan Szabo <[EMAIL PROTECTED]> wrote: >

Re: [SQL] sql programming

Make it text, then import it. You will have lots of tables. Send the check to :) --- Michael Wagner <[EMAIL PROTECTED]> wrote: > We need to export an SQL database to Excel. Is this > within your scope and what might your cost be? > > Please respond to Dan Beach > > [EMAIL PROTECTED] >

Re: [SQL] \copy...

Finally--a question I think I can answer! You need to specify what delimiters you use in your .dat file; the default for COPY is tab, but you can change that to | with copy tablename from '/home/ed/import.dat' delimiters '|' Hope this works...(oops--I mean 'helps') --- Ed <[EMAIL P