Hello Everybody!

Sorry, my English is very peer.

This is Database:

CREATE DATABASE TVGAR
WITH ENCODING='LATIN1'
OWNER=tvgaruser
TEMPLATE=template0
TABLESPACE=pg_default;
GRANT ALL ON DATABASE TVGAR TO GROUP "TVGAR";

This is Shema:

CREATE SCHEMA 'X' AUTHORIZATION postgres;
GRANT ALL ON SCHEMA 'X' TO postgres;
GRANT ALL ON SCHEMA 'X' TO public;
COMMENT ON SCHEMA 'X' IS 'abc';

X shema's table:

CREATE TABLE X.tabla (
razon bigserial,
2e00 varchar(11),
AS varchar(5)
....
...
..
PRIMARY KEY (razon)
) WITHOUT OIDS;

Fields name is not ok., denied : 'AS','1e00','2e00'

ERROR: Syntax error at to near "2e00" at character 1443

What is problem?

This support, very well thanks!

Áron József, Hungary


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Jozsef Aron wrote:
I believe this is normal as regards identifier names. The word "AS" is
probably reserved (sorry, haven't checked) and I don't think you can
start an identifier with a number.

So - if you want to use these names you must quote them:
CREATE TABLE zzz1 ("2e00" int4);

If you would like to discuss this further, subscribe to the
pgsql-general mailing list where there are lots of people who can help you.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings