Re: beginne' - inserting a record

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

On Sat, Dec 03, 2005 at 09:48:42PM +0100, Andrew Toth wrote:
>
> MediaBin=# insert into media values ("000", 120, "00001");
> ERROR: column "000" does not exist
>
> What the Hell could be wrong?

Your quotes. Use ' and that command will work.

Peter

I'm not familiar with version 8.1; however, you to use single quotes, not
double quotes as in:

INSERT INTO media VALUES ('000', 120, '00001');

That should work...

On Saturday 03 December 2005 03:48 pm, Andrew Toth saith:
> 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

On 3 Dec 2005 at 21:48, Andrew Toth wrote:

> MediaBin=# insert into media values ("000", 120, "00001");
> ERROR: column "000" does not exist

I think you should use single-quotes rather than doubles:

insert into media values ('000', 120, '00001');

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------

thx,

it's working!

And the last question - today:

how can i change the orter of the fields in a table?

2005-12-03, szo keltezéssel 20.59-kor Raymond O'Donnell ezt írta:

> On 3 Dec 2005 at 21:48, Andrew Toth wrote:
>
> > MediaBin=# insert into media values ("000", 120, "00001");
> > ERROR: column "000" does not exist
>
> I think you should use single-quotes rather than doubles:
>
> insert into media values ('000', 120, '00001');
>
> --Ray.
>
> -------------------------------------------------------------
> Raymond O'Donnell http://www.galwaycathedral.org/recitals
> rod(at)iol(dot)ie Galway Cathedral Recitals
> -------------------------------------------------------------
>

--

Tisztelettel: / Grüße / Yours sincerely,
Andrew Toth

Andrew Toth <tothaa(at)chello(dot)hu> schrieb:

> thx,
>
> it's working!
>
> And the last question - today:
>
> how can i change the orter of the fields in a table?

If you have a table with field1, field2, field3, and you want to see
this table as field3, field2, field1, simple do 'select field3, field2,
field1 from table'.

Btw.: TOFU (top posting with fullquote below) are silly.

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

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
>