Re: [SQL] Question regarding multibyte.

2007-02-04 Thread Karthikeyan Sundaram

Hi,

  I am new to postgres.  I asked a question regarding multibyte display.  I 
got only one response.

Hence, I am re-iterating the question again to a larger audience.

We are using 8.2 release of postgres.  Recently we converted our database to 
multibyte on our dev machine. we want to test the following.


  1) How will I insert multibyte from our php?  Do we need to use any 
special encoding?
  2) I am using psql command line to get the data into a flat file and push 
to our data warehouse

  We use IBM redbrick warehouse.
  3) If I have multibyte, I know the output from the psql will scatter to 
many lines.  How can we avoid that.  What is the sql command ? I need 1 
record per row to supply to our warehouse.


   Can somebody help me?

Regards
skarthi

_
Valentine’s Day -- Shop for gifts that spell L-O-V-E at MSN Shopping 
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline



---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [PHP] [SQL] Question regarding multibyte.

2007-02-04 Thread Michael Fuhr
On Sun, Feb 04, 2007 at 01:34:41PM -0800, Karthikeyan Sundaram wrote:
>   I am new to postgres.  I asked a question regarding multibyte display.  I 
> got only one response.
> Hence, I am re-iterating the question again to a larger audience.

pgsql-general would probably be the largest audience; maybe somebody
with access to list statistics can confirm or correct.

I responded to your original message in pgsql-admin; maybe you
haven't seen the response yet:

http://archives.postgresql.org/pgsql-admin/2007-02/msg00043.php

If the comments aren't helpful then please provide more information
about the difficulties you're having.  A minimal but complete example
that illustrates the problem might be useful.

-- 
Michael Fuhr

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org