On 8/31/07, Daniel Verite [EMAIL PROTECTED] wrote:
You can get the sizes from pg_largeobject, this way:
SELECT id_doc, sum(length(data)) as filesize
FROM documenti, pg_largeobject
WHERE documenti.file = pg_largeobject.loid
GROUP BY id_doc;
--
Daniel
PostgreSQL-powered mail user agent
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Thanks in advance...
With Regrads
Ashish...
On 01/09/07, Ashish Karalkar [EMAIL PROTECTED] wrote:
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Sure, write SQL in a program (php, perl, jsp, asp) to dump the tables
in HTML tabletrtd rows format. Then import that HTML page
program into Excel
Hello,
I have a simple query as follows. It joins two very straightforward tables.
SELECT
trades.id,
trades.url,
trades.alias,
tradecount.t_count,
tradecount.u_count
FROM trades
LEFT JOIN tradecount ON trades.id = tradecount.id
WHERE trades.user_id = 'jondoe' and trades.status = 'Y'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/07 02:16, Ashish Karalkar wrote:
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Extract the data to a CSV (comma or tab) file.
http://www.postgresql.org/docs/
Ashish Karalkar wrote:
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
ODBC is one way to do it.
Use the data import, that runs msquery
--
/Björn
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: In
On Aug 31, 2007, at 15:54, Martijn van Oosterhout wrote:
On Fri, Aug 31, 2007 at 02:42:18PM +0200, Alban Hertroys wrote:
Examples:
* random(maxrows) would return random rows from the resultset.
* median() would return the rows in the middle of the result set
(this
would require ordering to
On Sep 1, 2007, at 11:46, Phoenix Kiula wrote:
Hello,
I have a simple query as follows. It joins two very straightforward
tables.
SELECT
trades.id,
trades.url,
trades.alias,
tradecount.t_count,
tradecount.u_count
FROM trades
LEFT JOIN tradecount ON trades.id = tradecount.id
Markus Schiltknecht [EMAIL PROTECTED] wrote:
Hi,
Bill Moran wrote:
While true, I feel those applications are the exception, not the rule.
Most DBs these days are the blogs and the image galleries, etc. And
those don't need or want the overhead associated with synchronous
replication.
On Sep 1, 2007, at 12:44, Alban Hertroys wrote:
It would be possible to write an aggregate that returns a single
random
value from a set. The algorithm is something like:
n = 1
v = null
for each row
if random() 1/n:
v = value of row
n = n + 1
return v
Doesn't this always return
On Sat, Sep 01, 2007 at 02:24:25PM +0200, Alban Hertroys wrote:
Oh, now I see... The first time guarantees that v has a value (as
random() 1/1), and after that there is a decreasing chance that a
new row gets re-assigned to v. That means the last row has a chance
of 1/n, which would be
On 01/09/07, Alban Hertroys [EMAIL PROTECTED] wrote:
On Sep 1, 2007, at 11:46, Phoenix Kiula wrote:
.
..snip
However, there's a nested loop in there as the EXPLAIN ANALYZE shows
below. What is causing this nested loop?
It looks like it's used to match trades to tradecounts. I think
I am getting an error trying to connect to PostgreSQL db using Visual
Basic.NET 2005. The error message is FATAL: invalid command-line
arguments for server process. HINT: Try postgres --help for more
information.
Here is a the snippet of code to create connection. Looking for
suggestions on
Ever read anything on how myspace is laid out? The big ones need
replication to handle the traffic.
Actually no.
http://highscalability.com/livejournal-architecture
Using MySQL replication only takes you so far. (Yeh it's mysql but
the point is valid regardless).
You can't keep adding read
For quick/simple table format reports, you can just use psql to create
the output in HTML format, then import that directly into Excel. For
example, I use the following psql line to generate an HTML-format report
of server IP information; this file can then be directly opened in
Excel. (Excel
chris smith [EMAIL PROTECTED] wrote:
Ever read anything on how myspace is laid out? The big ones need
replication to handle the traffic.
Actually no.
http://highscalability.com/livejournal-architecture
Using MySQL replication only takes you so far. (Yeh it's mysql but
the point is
Anthony Brock (KG4AGD) [EMAIL PROTECTED] writes:
I am getting an error trying to connect to PostgreSQL db using Visual
Basic.NET 2005. The error message is FATAL: invalid command-line
arguments for server process. HINT: Try postgres --help for more
information.
This implies incorrect
Greetings to everyone
I have a PostgreSQL 8.2.4 installation running under Windows XP with WAL
archiving activated.
But at some point Postgres began to ask to archive a WAL segment that
isn't in the pg_xlog directory. I thought that a segment that isn't
succesfully
archived should remain in
On Sep 1, 2007, at 14:48, Phoenix Kiula wrote:
On 01/09/07, Alban Hertroys [EMAIL PROTECTED] wrote:
On Sep 1, 2007, at 11:46, Phoenix Kiula wrote:
.
..snip
However, there's a nested loop in there as the EXPLAIN ANALYZE shows
below. What is causing this nested loop?
It looks like
Phoenix Kiula [EMAIL PROTECTED] writes:
On 01/09/07, Alban Hertroys [EMAIL PROTECTED] wrote:
Is 10 ms problematic for this query?
I think you got 10ms from the query plan? These queries are very fast
after they have been executed once. But the first time is huge.
Sometimes I have to wait as
--- Ashish Karalkar [EMAIL PROTECTED] wrote:
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Excel has the ability to directly pull data from any system ODBC DSN configured
on the windows
box. Was is nice with this method is the ability for the users
On Sep 1, 2007, at 14:44, Martijn van Oosterhout wrote:
On Sat, Sep 01, 2007 at 02:24:25PM +0200, Alban Hertroys wrote:
Oh, now I see... The first time guarantees that v has a value (as
random() 1/1), and after that there is a decreasing chance that a
new row gets re-assigned to v. That means
Alban Hertroys [EMAIL PROTECTED] writes:
I am kind of surprised that the planner doesn't understand that a
foreign key with a unique constraint (which a primary key is) means
there is a 0..1 to 1 relationship with the target table.
Hm? It correctly estimated that it'd get one row out for
=?ISO-8859-1?Q?Norberto_Dell=EA?= [EMAIL PROTECTED] writes:
I have a PostgreSQL 8.2.4 installation running under Windows XP with WAL
archiving activated.
But at some point Postgres began to ask to archive a WAL segment that
isn't in the pg_xlog directory. I thought that a segment that isn't
On Saturday 01 September 2007 12:16 am, Ashish Karalkar wrote:
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Thanks in advance...
With Regrads
Ashish...
One relatively easy way to do it is to use the Base component of OpenOffice.
You can dump data
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/07 08:12, chris smith wrote:
Ever read anything on how myspace is laid out? The big ones need
replication to handle the traffic.
Actually no.
http://highscalability.com/livejournal-architecture
Using MySQL replication only takes
On Aug 29, 2007, at 5:15 AM, Jens Reufsteck wrote:
I'm having a strange performance issue with two almost similar
queries, the
one running as expected, the other one taking far more time. The only
difference is that I have uniid in (10) in the normally running
query and
uniid in (9,10) in
27 matches
Mail list logo
