Search results for query: *

Hi all, I am faced with the need to create a postgres user that has only select/update/insert/delete priviledges but not be able to create users, databases, alter tables, create tables, so on and so on. Has anyone done this with postgres? When I check the help file for create user, the only...

I would love to be able to find certain files within a given directory that have a specific permision set. I tired this....but I failed (hence my post) ls -l | grep -rw------- Im sure it has something to do with special characters (-) Does anyone have any advice for me?

Hi all, I have a very large directory of files of differing types and I need to seperate them based on file type. For example, I need to copy all of the pdfs into a temp directory. I tried this but got an error unix-shell:# cp *.pdf temp_pdf_dir/ bash: /bin/cp: Argument list too long Can...

Ok, so my DBA labeled a column "ORDER" which is a SQL reserved work. Not smart. Unfortunately I cant take the time to drop the column, re-add at it with a new name and dump the data back in. This sucks. I am trying to save the MIS folks some heartache by using copy to dump a bunch...

Hi all and thanks for reading my post. I have an Oracle 9i Db running on a remote server (Linux) and I would like to create a visual map of the schema. Is this possible with Visio 2001?

Hello all and thanks for reading my post. I have a table in my oracle db that is tracking user comments/notes for each record that is entered. The problem is, the notes are chock full of tabs, carriage returns, white space, commas and other punctuation. When I run a select statement on this...

Hello all and thanks for reading my post. In the past I have used the DATEDIF function in excel to determine the delta of two dates. This delta is always one day less than the actual duration. This makes sense because a difference is not the same a duration :-) I was wondering if anyone new...

Ok, thanks for reading my post, Im a n00b and could use some help. I use the DATEDIFF function a lot two fine the delta between to dates. Example... A B C 1 start end delta 2 2-27-04 3-1-04 3 <---=DATEDIFF(A2,B2&quot;d&quot;) what I would love to do is populate...

Hi All, thanks for reading my post. I am using a Postgres 7.3 and I have a query that contains lots of empty values, not null really, white space (the php code isnt mine) Anyway, Im trying to format a report and I want to concatenate commas between my case statements like so select id||', '||...