Klint Gore <[EMAIL PROTECTED]> writes:
> David Wilson wrote:
>> I'm not certain how to check the actual byte width of a column within a
>> row,
> select length(bytea_field) from table
If you want the actual on-disk footprint, use pg_column_size()
regards, tom lane
--
Se
David Wilson wrote:
On Mon, Jul 28, 2008 at 1:24 AM, Klint Gore <[EMAIL PROTECTED]> wrote:
> Try just a single \
>
> e.g.
> "ge.xls","application/vnd.ms-excel",71168,"\320\317\021\340\241[snip]
Thanks- I did try that, and it at least gave the expected output from
select, but is there a way to ve
On Mon, Jul 28, 2008 at 1:24 AM, Klint Gore <[EMAIL PROTECTED]> wrote:
> Try just a single \
>
> e.g.
> "ge.xls","application/vnd.ms-excel",71168,"\320\317\021\340\241[snip]
Thanks- I did try that, and it at least gave the expected output from
select, but is there a way to verify that it's actuall
David Wilson wrote:
My application is adding a bytea column to a table into which data is
dumped in approximately 4k row batches, one batch approximately every
10 seconds. To this point, those dumps have used copy from stdin;
however, I'm having some difficulty getting bytea encodings to work
wit
aravind chandu wrote:
> Hi,
>
> I have some data in XML format and i need to upload in postgresql
> database using stored procedure. Can someone tell
> me the step by step procedure of the same as i will be doing it for the
> first time.
As Stephanie Bortzmeyer already explained to you, the
My application is adding a bytea column to a table into which data is
dumped in approximately 4k row batches, one batch approximately every
10 seconds. To this point, those dumps have used copy from stdin;
however, I'm having some difficulty getting bytea encodings to work
with it. Specifically, I
configure postgres with the following options
1. ./configure --enable-profiling
2. make and make install
3. start psql and issue the query
4. gmon.out will be in the data directory once you exit from psql
-Sushant.
On Sun, 2008-07-27 at 05:55 -0700, Suresh wrote:
>
> Hello,
>
> I want to prof
[EMAIL PROTECTED] wrote:
You can do it in straight sql like so.
SELECT (array[col1, col2, col3, col4, col5, col6, col7, col8, col9, col10])[i]
FROM test t, generate_series(1,10) i
Art
Hi Art,
Thanks for the advice, in my case using arrays was not a option as the
data could be null.
Stev
Klint Gore wrote:
Steve Martin wrote:
I am trying to create a PL/PGSQL function to return the values of the
fields in a record, e.g. 1 value per row in the output of the function.
How do you substitute a variable?
CREATE OR REPLACE FUNCTION testfunc() RETURNS SETOF text AS $$
DECLARE
Roberts, Jon wrote:
What I am trying to do is find the difference between two tables, one
that stores the
information in a single column, and the other which stores the same
data
in multiple
columns.
E.g.
CREATE TABLE test(col1 text, col2 text, col3 text, col4 text, col5
text,
On Mon, 28 Jul 2008, Andrej Ricnik-Bay wrote:
Can you do a 'locate pg_ctl|xargs ls -l' and see whether you have more
than one installed, and if so, which one comes first in the PATH?
Andrej,
There are two:
-rwxr-xr-x 1 root root 24320 2008-06-17 16:18 /usr/bin/pg_ctl
-rw-r--r-- 1 root root
Hello,
I want to profile some functions in postgres using gprof. I am following this
procedure listed in nabble forum.
# cd postgres/bin
# cd .../src/backend
# make clean
# make PROFILE="-pg" all
How to proceed after this ? I am not getting the gmon.out file. How do I run
./postg
2008/7/28 Rich Shepard <[EMAIL PROTECTED]>:
> Thank you. I think that for some reason using pg_ctl to start the
> postmaster is no longer working here. As I have time, I'll look into why.
Can you do a 'locate pg_ctl|xargs ls -l' and see whether you have more than one
installed, and if so, which on
Dear Sirs,
when I execute a function that returns an error, visual basic shows always
the same error code ( -214767259) but I would like to know the real postgres
code of the error.
The visual basic code that I use is the following:
Dim Cmd As new ADODB.Command
Cmd.CommandText = "delete from wh
Hi,
I have some data in XML format and i need to upload in postgresql database
using stored procedure. Can someone tell
me the step by step procedure of the same as i will be doing it for the
first time.
Thank You,
Avin.
On Sat, Jul 26, 2008 at 02:32:05PM -0700,
aravind chandu <[EMAIL PROTECTED]> wrote
a message of 149 lines which said:
> I have to load xml file data into postgresql database
> table using a stored procedure,but I didn't have any
> idea how to start it.
Well,
On Sun, 27 Jul 2008, Andrej Ricnik-Bay wrote:
I thought we had established that this issue was caused by the current
instance pointing at the old installs data directory?
No, that wasn't the problem.
If I use 'postgres -D /var/lib/pgsql/data &' the postmaster starts
correctly and everythi
17 matches
Mail list logo