[GENERAL] Reg: Permission error in Windows psql while trying to read sql commands from file

2008-10-11 Thread Raj K
Hi all, I am a DB newbie and I am facing an issue. I installed postgresql in windows - and now I am facing an issue while trying to read sql commands from file. testdb=# \i c:\testdb.txt c:: Permission denied I tried moving the file to the shared folder, but of no use. testdb=# \i

Re: [GENERAL] Reg: Permission error in Windows psql while trying to read sql commands from file

2008-10-11 Thread Raj K
\All Users\Documents\ - which I did. But even that did not help - as mentioned in the first mail. If you could help me on this I would be much obliged.. Regards Raj On Sat, Oct 11, 2008 at 11:11 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote: > On 11/10/2008 18:38, Raj K wrote: >

Re: [GENERAL] Reg: Permission error in Windows psql while trying to read sql commands from file

2008-10-13 Thread Raj K
12, 2008 at 11:47 PM, Josh Williams <[EMAIL PROTECTED]> wrote: > On Sun, 2008-10-12 at 09:25 +0530, Raj K wrote: > > Since it is in windows - I could not find any specific file permission > > mechanisms similar to linux. (This is my first foray in windows - so I > > am a

[GENERAL] Reg: Custom Data Types in PostgreSQL

2008-11-21 Thread Raj K
Hi all, I am not an expert in DB. So please excuse, if the question is stupid. In PostgreSQL, we do support custom data types - say enum type. --> CREATE TYPE testtype AS ENUM {'test1', 'test2'}; Now, I was wondering whether we should be using a different table or the enum itself f