Dear List,
I have managed some small databases with FoxPro, but something is not known by me to manage postgresql databases
I had created a database as 'postgres' user and I tried the following as 'postgres' user too under Debian SID with postgresql 8.1:
(it seems to be a Hungarian version
- FoxPro couldn't speak Hungarian)
# psql MediaBin
[...]
MediaBin=# \d media
Tábla "public.media"
Oszlop | Típus | Módosító
----------+--------------+----------
type | character(3) |
capacity | smallint |
mid | character(5) |
MediaBin=# insert into media values ("000", 120, "00001");
ERROR: column "000" does not exist
MediaBin=#
What the Hell could be wrong?
--
Tisztelettel: / Grüße / Yours faitfully, Andrew Toth
|