deparse altered "CREATE TABLE" statement, removed quotes from CONSTRAINT name

[divyenduz]

Original query (with fingerprint 91291afafdacd92a):

CREATE TABLE "Album"
(
  "AlbumId" INT NOT NULL,
  "Title" VARCHAR(160) NOT NULL,
  "ArtistId" INT NOT NULL,
  CONSTRAINT "PK_Album" PRIMARY KEY  ("AlbumId")
)

Deparsed query (with fingerprint d37da9dd17c1175d):

CREATE TABLE "Album" (
 	"AlbumId" int NOT NULL,
	"Title" varchar(160) NOT NULL,
	"ArtistId" int NOT NULL,
	CONSTRAINT PK_Album PRIMARY KEY ( "AlbumId" ) 
);

In the deparsed query, double quotes around PK_Album are removed. I am not sure if this makes the queries different but since the fingerprint changed, I raised this issue.

This is also true for "ALTER TABLE". Please let me know if I should open a separate issue for that.

To reproduce:

const fs = require('fs')
const { parse, deparse } = require('pgsql-parser');

async function main() {
    const stmts = parse(`
CREATE TABLE "Album"
(
  "AlbumId" INT NOT NULL,
  "Title" VARCHAR(160) NOT NULL,
  "ArtistId" INT NOT NULL,
  CONSTRAINT "PK_Album" PRIMARY KEY  ("AlbumId")
)
    `)
    const stmts2 = deparse(stmts[0])
    console.log(stmts2)
}

main()

Schema at https://github.com/prisma/database-schema-examples/tree/main/postgres/chinook

[pyramation]

Thanks so much for the detailed issue — and apologies for the delay! I've been building this deparser from the ground up, so I really appreciate your thorough input and patience.

I've just published the updated package. Please give it a try and let me know if you run into any other issues!