[GENERAL] Confused with db client encoding

Hi, Here is the output a psql session. Please notice that the identation inconsistences in the records containg non ASCII chars is as outputed by psql. The db was created with LANIN9 and the console was ran (in the same machine) using UTF-8 (my system's default). I was surprised to notice that s

Re: [GENERAL] "echo"ing a psql command in a bash script

* Jim Wilson <[EMAIL PROTECTED]> [030904, 14:39]: > Ennio-Sr said: > > > (once for all): > > cmnd=echo psql mydb -x -c "SELECT * FROM tb_nm WHERE $col_nm LIKE '%$k_r%'" > > That will be executed immediately, and give you an error. In fact, yes, you're right! it gives ...but after the second Ent

[GENERAL] Schema and Group permissions question

I'm setting up a system to use schemas: DB ---+ | | | | Schemas:Prod Test FuncsTestFuncs | | tables tables This sort of arrangmenet allows me to have a Production s

Re: [GENERAL] Indexing Order By columns

[EMAIL PROTECTED] (Hadley Willan) wrote: >     Can it speed things up to index the order by columns? Certainly. -- If this was helpful, rate me http://cbbrowne.com/info/linuxdistributions.html "Microsoft is sort of a mixture between the Borg and the Fere

[GENERAL] how to query the size of an array in a table

Hello... Is it possible in PostGre 7.3 to query the size of a text[] array attribute of a table? Does anyone know how this is queried in 7.3? thanks... help is greatly needed. eddie

[GENERAL] So, would it make sense to do something like a CRC on each record? (was How to determine a database is intact?)

Pardon me for this, but it's Monday morning here and I'm in shallow thinking mode. I was just looking over Wes's questions about checking database integrity, and the responses given, and I'm wondering if keeping a live CRC on each record would make sense? Or is this already done, or maybe an opti

Re: [GENERAL] One Database per Data File?

Oops! Randy Yates <[EMAIL PROTECTED]> was seen spray-painting on a wall: > I'm a complete newbie to postgres so please look the other way if > these questions are really stupid. > > Is it legitimate to have one database per data file? For > organizational and backup purposes, I'd like to keep the d

Re: [GENERAL] how to query the size of an array in a table

Po Eddie Lim wrote: Is it possible in PostGre 7.3 to query the size of a text[] array attribute of a table? Does anyone know how this is queried in 7.3? It isn't well documented, and not convenient to use, but see array_dims() function on this page: http://www.postgresql.org/docs/7.3/interactive