Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
psql (9.0.4)
WARNING: Console code page (866) differs from Windows code page (1251)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=# \connect l2jdb;
WARNING: Console code page (866) differs from Windows code page (1251)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
You are now connected to database "l2jdb".
l2jdb=# \d accounts
Table "public.accounts"
Column | Type | Modifiers
--------------+-----------------------------+-----------------------------------
-----
login | character varying(45) | not null default ''::character var
ying
password | character varying(45) |
lastactive | timestamp without time zone | not null
accessLevel | smallint | not null default 0
lastIP | inet |
lastServer | smallint | default 1
userIP | inet |
pcIp | inet |
hop1 | inet |
hop2 | inet |
hop3 | inet |
hop4 | inet |
creationTime | timestamp without time zone |
Indexes:
"accounts_pkey" PRIMARY KEY, btree (login)
Check constraints:
"lastServCheck" CHECK ("lastServer" > 0)
Referenced by:
-- More --