The following bug has been logged on the website:
Bug reference: 13655
Logged by: David
Email address: stormbyte@gmail.com
PostgreSQL version: 9.4.4
Operating system: Gentoo Linux
Description:
When using field names with "", and custom data type, with its name also
with "", a syntax error is triggered in CREATE TABLE when tab character is
used instead of spaces.
To reproduce, create a sql file with: (Insert tab and NOT space when <TAB>
is specified)
CREATE TYPE "GPSPoint" AS ("lat" DECIMAL(9,6), "lon" DECIMAL(9,6));
CREATE TABLE "TestTable" ("testGPS"<TAB>"GPSPoint" NOT NULL);
Save it, and copy/paste to psql, you will see an syntax error near NOT.
That is workarounded by inserting <SPACE> before or instead of <TAB>, but
should not trigger any syntax error, as the same syntax works for bundled
types, so the following does not fail:
CREATE TABLE "TestTable" ("test"<TAB>SMALLINT NOT NULL);
This is a low priority bug, but a bit annoying