On Sat, Dec 03, 2005 at 09:48:42PM +0100, Andrew Toth wrote:
>
> MediaBin=# insert into media values ("000", 120, "1");
> ERROR: column "000" does not exist
>
> What the Hell could be wrong?
Your quotes. Use ' and that command will work.
Peter
---(end of broadcast
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 postgresq
On 3 Dec 2005 at 21:48, Andrew Toth wrote:
> MediaBin=# insert into media values ("000", 120, "1");
> ERROR: column "000" does not exist
I think you should use single-quotes rather than doubles:
insert into media values ('000', 120, '1');
--Ray.
-
Andrew Toth <[EMAIL PROTECTED]> 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, fie
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, "1");
> ERROR: c
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, '1');
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 some
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
