dont use " user '
Andrew Toth wrote:
>
> 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
>