markc@renta.net schrieb:
> Please excuse my naivety as I have never used postgresql. Could
> anyone please let me know if there is any char length limit for the
> username that logs into the database itself ?
>
experiment=# \d pg_user
View "pg_catalog.pg_user"
Column | Type | Modifiers
-------------+---------+-----------
usename | name |
usesysid | integer |
usecreatedb | boolean |
usesuper | boolean |
usecatupd | boolean |
passwd | text |
valuntil | abstime |
useconfig | text[] |
View definition:
SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb,
pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd,
pg_shadow.valuntil, pg_shadow.useconfig
FROM pg_shadow;
http://www.postgresql.org/docs/8.1/interactive/datatype-character.html
"name 64 bytes internal type for object names"
Does this answer your question?
Regards
Tino Wildenhain