beginne' - inserting a record

From: Andrew Toth <tothaa(at)chello(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: beginne' - inserting a record
Date: 2005-12-03 20:48:42
Message-ID: 1133642923.9402.20.camel@edvac4
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Wiersig 2005-12-03 20:51:03 Re: beginne' - inserting a record
Previous Message Terry Lee Tucker 2005-12-03 20:45:47 Re: hello