Re: [SQL] Encrytion in postgres field in table

2008-07-28 Thread Andrej Ricnik-Bay
On 29/07/2008, Chris Preston [EMAIL PROTECTED] wrote: How do I setup a password table that I only want to encrypt 1 field password http://www.postgresql.org/docs/8.3/interactive/pgcrypto.html -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

Re: [SQL] select across two database

2008-06-16 Thread Andrej Ricnik-Bay
On 17/06/2008, Jorge Medina [EMAIL PROTECTED] wrote: hi guys. I want know if it's possible create a select from 2 database or create a view in one of them. The short answer is no. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription:

Re: [SQL] Extract interdependent info from one table

2008-01-25 Thread Andrej Ricnik-Bay
On 25/01/2008, Phillip Smith [EMAIL PROTECTED] wrote: Absolutely clear as mud :P sorry ... I'm not too good with expressing my SQL needs, I'm afraid, Thanks for trying :} In the end I got it sorted with the following select dm.docnum, dm.alias1, dm.docname, dm.alias2 as Status,

[SQL] Extract interdependent info from one table

2008-01-24 Thread Andrej Ricnik-Bay
Hi Guys, I can't quite wrap my head around this one ... I have \d docmaster Table public.docmaster Column | Type | Modifiers ++--- alias1 | integer| alias2 | character

Re: [SQL] Restricting columns by users

2007-08-07 Thread Andrej Ricnik-Bay
On 8/8/07, Ranieri Mazili [EMAIL PROTECTED] wrote: Exist something like it for postgresql? I thought that's what views are for Thanks Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm

Re: [SQL] Converting from MS Access field aliases

2007-07-13 Thread Andrej Ricnik-Bay
On 7/13/07, Nis Jørgensen [EMAIL PROTECTED] wrote: Don't attribute to malice what can be adequately explained by incompetence. He didn't :) Nis Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm

Re: [SQL] linux

2007-07-11 Thread Andrej Ricnik-Bay
On 7/12/07, Mohd Ghalib Akhtar [EMAIL PROTECTED] wrote: how to download linux 7.3 image file(means os) ? Please, for the sake of people who use mailing systems that support threading start a new mail for a new topic. Don't just respond to one you spotted and change the subject. Highly

Re: [SQL] yet another simple SQL question

2007-07-01 Thread Andrej Ricnik-Bay
On 7/2/07, John Summerfield [EMAIL PROTECTED] wrote: Andrej: I don't post links; I often find them unhelpful because I can't read them at the time I'm reading email. esr's article contains good advice, but there's room for argument on some of his points. Probably, not everyone will agree with

Re: [SQL] yet another simple SQL question

2007-06-26 Thread Andrej Ricnik-Bay
On 6/27/07, Michael Glaesemann [EMAIL PROTECTED] wrote: While self-admittedly grumpy, I believe John was trying to encourage better posting behavior from Joshua which will benefit him by receiving more answers. If John had remained silent (as I'm sure others who share his sentiment have), being

Re: [SQL] need help

2007-05-14 Thread Andrej Ricnik-Bay
On 5/14/07, Penchalaiah P. [EMAIL PROTECTED] wrote: Any one can help in this Operating system? Postgres version? How does psql behave? Anything in the logs? Cheers, Andrej ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [SQL] We all are looped on Internet: request + transport = invariant

2007-04-19 Thread Andrej Ricnik-Bay
On 4/19/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Problem consist of transportation data, received by SQL, into external world. As i already wrote, it's very difficalt for users (in practice) to use libraries of additional language (php , perl, etc) for that. I offer to put one feature

Re: [SQL] Issue with copying data from a text file.

2007-03-19 Thread Andrej Ricnik-Bay
On 3/20/07, Paul Lambert [EMAIL PROTECTED] wrote: The source file comes from extracts on our main application which sits inside an in-house pretending-to-be-a-dbms file system. The content of these extracts would be difficult to change - the extract program would need to parse the data looking

Re: [SQL] postgres configuration

2007-03-13 Thread Andrej Ricnik-Bay
On 3/14/07, Sumeet [EMAIL PROTECTED] wrote: Hi All, Hi, Sorry if this is the wrong list to ask this question. General woould have been better :) My Vacuum's are running very very slow and expecially when vacuuming indexes in large tables of size in 5-10 gigabytes, can some one help me

Re: [SQL] SHA-1 vs MD5

2007-03-07 Thread Andrej Ricnik-Bay
On 3/8/07, Andrew Sullivan [EMAIL PROTECTED] wrote: What is the problem you're trying to solve? Md5 is probably good enough for many cases, but for long-term use, you're right that sha-1 is what you need. Actually, you need sha-256, quite frankly. Looking at his last mail he's after a

Re: [SQL] How to store a password encripted in a user defined table

2007-03-01 Thread Andrej Ricnik-Bay
On 3/1/07, Eugenio Flores [EMAIL PROTECTED] wrote: Hello, I wonder if somebody knows how to store passwords in a column that is part of a user defined table. Assuming that your passwords are application specific use a sha1 or md5 algorithm (depending on how sensitive your data is) and store