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
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
, 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
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
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 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
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
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
;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
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
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 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
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
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
14 matches
Mail list logo
