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...

thanks guys, you RAWK!!

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?

Thanks to all for their input. cp was dying because the list of pdf files was too great to it puked and died. This is the command I eventually came up with. find . -iname '*.pdf' -print0 | xargs -0 -n 1 cp --target-directory=temp_pdf_dir/ Thanks again to all that helped out. Your the best.

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...

DERP!!! the answer came to me. I made the table name lower case and blammo, the thing worked. Spank my ass and call me charlie. Thanks anyway.

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?

TONY YOU ROCK!!! Thanks to all who helped me, you have made my morning that much better.

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...

Thanks to all, basically, if a start date is the 1st and the end date is the 10th (and for the sake of simplicity, lets assume that we are working 7 days a week) then the duration is 10 days because we work on the first but when I used the datedif function, it returns a value of 9. Thats my...

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...

Tony, You Rock!!! Thanks for the reply, you helped me out!! 10-Pound

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...

WORD, yeah Im running my SQL straight into the backend so Im not touching any of the php code but thanks for the heads up.

Thanks for the heads up and advice swampboogie!!

wow, it appears all I have to do is post and the answer will come to me. when I end my case argument, I had as <column_name)>||', '|| which causes the sql to parse error, remove that and add the cat string and blammo, works fine for what I needed. Thanks.

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||', '||...