I have a table of paragraphs for pages that are in a specific order (1st,
2nd, 3rd, etc...).
demo=# \d paragraphs
Table "toolbox.paragraphs"
Column| Type |Modifiers
-+-+---
EXPLAIN ANALYZE SELECT page, count(page) as impressions FROM
campaign_impressions WHERE campaign = 42 and "timestamp" BETWEEN '2010-05-21
00:00:00' AND '2010-07-27 00:00:00' group by page order by impressions;
QUERY PLAN
--
I'm trying to increase my query speed for this table, it currently takes 2-3
seconds and would like to make if faster if possible.
my table reads as
Table "public.campaign_impressions"
Column |Type | Modifiers
---+-+
I have an application in a schema and now i need to create other schemas b/c
the app needs to support different languages, is there an easy way to copy
an entire schema to a new one (tables, contents, trigges, functions, etc..)?
right now i just have
- schema
what I want is
- schema
My company has a handful of apps that we deploy in the websites we build.
Recently a very old app needed to be included along side a newer app and
there was a conflict w/ a duplicate table name needed to be used by both
apps.
We are now in the process of updating an old app and there will be some
I'm looking for a data generator. Free would be nice, if possible. Has
anyone had good luck w/ anything? maybe point me in a good direction :)
Thanks,
Jamie K.
I need a function like regexp_split_to_table where I can split a string to a
table by a space delimiter.
so:
Please Help Me
would convert to:
Please
Help
Me
However I'm stuck working w/ version 8.2.9, so I don't have the
regexp_split_to_table function. Is there any good functions that can hand
what would be considered "best practice" for my situation?
I have a table *member*, with column *name *that I want to put an index on,
because it is searched quiet frequently. When I create my sql search string,
the name will consist only of alpha-numeric characters and be compared
against lowerca