match the
encoding expected by the server, which is controlled by "client_encoding".
I understand the error message - but what I don't know is what I need to set
the encoding to - in order to import / use the data.
As always - thanks in advance for any help you might be able
PM, Jasen Betts wrote:
> On 2011-02-08, Gavin Beau Baumanis wrote:
>
>> I understand the error message - but what I don't know is what I
>> need to set the encoding to - in order to import / use the data.
>
> if you run it through
>
> iconv --from-cod
That way you have "local" access to the DB and all of it's tools too.
You can "play around" with it to your hearts content, run SQL
"scenarios" / test functions etc on your own copy of the DB.
Then when you're happy - perform the "locally tested" SQL
an
you direct them to provide the things I need?".
Bart Degryse wrote:
>>> Gavin 'Beau' Baumanis <[EMAIL PROTECTED]> 2008-02-15 12:46 >>>
>The windows installer, available at;
>http://www.postgresql.org/ftp/win32/
>Allows you to install the DB an
Hi Everyone,
I have asked our DBA at work and h is not too sure either... so I
thought it best to on the list.
Basically, what I am after is a way to copy the contents of one record
into another.
Something like select into; but where the destination record already
exists, as opposed to cr
19 PM, A. Kretschmer <[EMAIL PROTECTED]
> wrote:
am Thu, dem 20.03.2008, um 20:57:53 +1100 mailte Gavin 'Beau'
Baumanis folgendes:
> Hi Everyone,
>
> I have asked our DBA at work and h is not too sure either... so I
> thought it best to on the list.
>
> Basic
Hi Everyone,
I want to thank everyone for their help / suggestions...
I really appreciate it.
Though I think I have found a winner.
craig=# update x set val = foundrow.val from ( select val from x
where id = 2 ) as foundrow where id = 1 ;
UPDATE 1
Very elegant, very clean...
Very nice!
T
;2008-04-10'} format
as being a valid date data type...
But it works elsewhere in the application / on other sites - thus my
current state of confusion.
Thanks in advance for any ideas you might have.
Please contact me if you should have any questions.
Gavin 'Beau' Baumanis
01-23'}
The weirdness for me is that it works elsewhere in the application, I
am really stumped.
-Gavin.
On 10/04/2008, at 4:17 PM, Aarni Ruuhimäki wrote:
On Thursday 10 April 2008 03:14, Gavin 'Beau' Baumanis wrote:
Hi Everyone,
I have a question about dates, please.
I
Hi Everyone,
After spending some time searching through our good friend Mr. Google
and the mailing list I found a post that provided me with a query that
does just what I need.
However, the query takes FOREVER and although this is stated in the
original mail I thought I would ask if there
Hi Everyone,
I am hoping that you might be able to give me some assistance with the
following task!
I have a database with nearly 200 tables and I need to find all tables
that contain a column of myColumnName.
I was hoping there might be a built-in function for this task, but I
have been
08 at 11:51:20PM +1000, Gavin 'Beau' Baumanis wrote:
I am hoping that you might be able to give me some assistance with
the
following task!
I have a database with nearly 200 tables and I need to find all
tables
that contain a column of myColumnName.
select * from information_schem
Hi Everyone,
I am having some issues trying to create the required SQL that will
allow me to return the results I am after.
I have been trying various incarnations, using group by, sub-queries -
albeit to no avail - for the past three hours.
Consider the following simple SQL;
select
a
, Tom Lane wrote:
"Gavin 'Beau' Baumanis" <[EMAIL PROTECTED]> writes:
... If there a multiple rows of the same id in table1, I get all
(multiple) rows - as you would expect - of course.
What I need however, is only one row returned per instance a.id that
is returned
14 matches
Mail list logo
