Re: [GENERAL] storing latitude and longitude

2008-07-10 Thread Ismael Almaraz Ezparza
Sorry I'm not of much help but... did you check the data types page? http://postgresql.mirrors-r-us.net/docs/8.2/interactive/datatype-geometric.html http://postgresql.mirrors-r-us.net/docs/8.2/interactive/datatype-numeric.html That mainly depends on how many digits you need to store, if that's no

Re: [GENERAL] How to obtain info about the user?

2008-07-10 Thread Ismael Almaraz Ezparza
n Thu, 2008-07-10 at 11:08 -0500, Ismael Almaraz Ezparza wrote: >> Hi there, >> I'm connecting to postgres from java using the postgres driver... >> and I need to get the info about the user that is connected to the DB, lets >> say >> for example: name, groups, permis

[GENERAL] How to obtain info about the user?

2008-07-10 Thread Ismael Almaraz Ezparza
Hi there, I'm connecting to postgres from java using the postgres driver... and I need to get the info about the user that is connected to the DB, lets say for example: name, groups, permisions (select, update, execute)... Does anyone knows how can I get that info? Also, if the user is in the gr