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