On Thu, Apr 8, 2010 at 1:52 PM, dipti shah wrote:
> techdb=> select * from techtable;
> ERROR: permission denied for relation techtable
> techdb=>
>
> ...and it gives permission denied..!
This should work:
SELECT description from techtable;
UPDATE techtable SET description = 'xyz'
This should n
On Thu, Apr 8, 2010 at 1:41 PM, dipti shah wrote:
> Okay. I think I got it but it is not working the way it should. I have given
> select permission on one column but still it is displaying both the columns.
> Could you please tell me what is wrong.
>
>
> techdb=# GRANT SELECT (description), UPDAT
>On Thu, Mar 25, 2010 at 11:25 AM, Andre Lopes wrote:
> Hi,
>
> I'm using Varchar(16) to store an IP Address. PostgreSQL offers another
> datatypes to store IP's or it is OK to store in Varchar(16)?
>
> Best Regards,
>
Yes, just look here:
http://www.postgresql.org/docs/8.4/static/datatype-net-ty
On Mon, Mar 8, 2010 at 9:17 AM, Albe Laurenz wrote:
> Mary Y Wang wrote:
>> I got the following error and not sure how to fix it.
>> "psql:/tmp/030610dumpfile.txt:4369: ERROR: invalid byte sequence for
>> encoding "UTF8": 0x93
look here:
http://www.depesz.com/index.php/2010/03/07/error-invalid-
