Re: > ERROR: syntax error at or near "BYTE"

[Paul Förster <paul.foerster@xxxxxxxxx>]

Hi,

> On 21. Aug, 2020, at 10:19, postgresdba111@xxxxxxxxxxx wrote:
> 
> CREATE TABLE "A"
> (
>   "b"                 DATE,
>   "c  "               NUMBER,
>  " d "                  VARCHAR2(255 BYTE),
>   "e "            VARCHAR2(255 BYTE))
>   
>   When ı create table then after error why error in byte please heplp me thanks
>   
>   error:> ERROR:  syntax error at or near "BYTE"

several problems:

a) don't put blanks in your names, neither table names nor attributes.
b) PostgreSQL doesn't have NUMBER. Use integer instead.
c) PostgreSQL doesn't have VARCHAR2. User text instead.

So, the correct statement would be:

create table a (
    b date,
    c integer,
    d text,
    e text
);

Hope this helps.

Cheers,
Paul