New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

postgres create table script does not include sequence information #14

Open

MasterOdin opened this issue Sep 23, 2020 · 0 comments

Member

MasterOdin commented Sep 23, 2020

The following SQL:

CREATE TABLE "test" ("id" serial PRIMARY KEY, "col1" varchar(255) NOT NULL DEFAULT '', "col2" integer NULL);

is returned as:

CREATE TABLE public.test (
  id integer NOT NULL,
  col1 character varying(255) NOT NULL,
  col2 integer NULL
);

ALTER TABLE public.test ADD CONSTRAINT test_pkey PRIMARY KEY (id)

for the create script. The id column does not have the attached sequence anymore.

The text was updated successfully, but these errors were encountered:

MasterOdin transferred this issue from sqlectron/sqlectron-core

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment