On 8/24/06, Sumeet <[EMAIL PROTECTED]> wrote:
Hi Folks,sorry if this is a duplicate post, i've been tryin to find a solution of importing data into postgres from a csv file. The problem is, I have a database which consists of columns which contain newline characters (mac and unix). now when i expor
On 8/24/06, Travis Whitton <[EMAIL PROTECTED]> wrote:
Hello all, I'm running the following query on about 6,000 records worth
of data, and it takes about 8 seconds to complete. Can anyone provide
any suggestions to improve performance? I have an index on
two columns in the transacts table (program_
> You can accomplish what assertions do using triggers.
> I think the issue is generating triggers for general assertions that don't
> totally suck performancewise.
Ah, I see. So the points is that checking the integrity between two complete
data sets can become
a preformace killer.
Thanks for
On Sun, Aug 27, 2006 at 00:19:59 -0700,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Sorry if my question is a little off topic.
>
> I am reading my new "SQL for Smarties" book side by side with the PostgreSQL
> 8.1 manual. I
> noticed that this particular feature is not included in Postgr
Sorry if my question is a little off topic.
I am reading my new "SQL for Smarties" book side by side with the PostgreSQL
8.1 manual. I
noticed that this particular feature is not included in PostgreSQL. Some of
the achieve threads
mostly discuss that this feature is currently not supported. My
