am Tue, dem 11.11.2008, um 14:57:20 +0100 mailte Bart van Houdt folgendes:
> Hi all,
Please, don't hijack other threads.
>
> This might be a stupid question, but I wasn't able to find any information on
> it, so here it goes:
> Oracle knows a view which contains information about indexed colu
Cool!
Thx :D
Bart van Houdt
Syfact International B.V.
Database developer
-Original Message-
From: Mario Splivalo [mailto:[EMAIL PROTECTED]
Sent: dinsdag 11 november 2008 15:03
To: pgsql-sql@postgresql.org
Cc: Bart van Houdt
Subject: Re: [SQL] Postgres version of all_ind_cols
Bart van Ho
Bart van Houdt wrote:
Hi all,
This might be a stupid question, but I wasn't able to find any information on
it, so here it goes:
Oracle knows a view which contains information about indexed columns
(all_ind_cols), is there something similar available in Postgres?
I want to be able to create a
Hi all,
This might be a stupid question, but I wasn't able to find any information on
it, so here it goes:
Oracle knows a view which contains information about indexed columns
(all_ind_cols), is there something similar available in Postgres?
I want to be able to create an full overview of each
Mario Splivalo wrote:
But, if I want it other way around, I get the error:
test1=# select envode(E'\305', 'hex');
ERROR: invalid byte sequence for encoding "UTF8": 0xc5
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlle
Tom Lane wrote:
Mario Splivalo <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Exactly what version of pg_dump are you using? What I get from pg_dump
doesn't look like that. Bytea fields with -D look more like this:
INSERT INTO foo (f1) VALUES ('\\305S\\224\\226\\203)');
Yes, I mistakenly used
Richard Huxton wrote:
Mario Splivalo wrote:
Richard Huxton wrote:
Mario Splivalo wrote:
I have this issue:
postgres=# select E'\xc5\x53\x94\x96\x83\x29';
ERROR: invalid byte sequence for encoding "UTF8": 0xc553
I think you want to be using octal escapes. That's text you're
generating above.
