#768 [PostgreSQL 10] Export sequences and indexes

[LacaK]

Adminer exports some sequences as:
CREATE SEQUENCE authmap_aid_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START CACHE 1;

after "START" there is missing value!

And some indexes, which contain function like substr() are exported as (see empty ""):

CREATE INDEX "locales_source_source_context_idx" ON "public"."locales_source" USING btree ("", "context");

CREATE INDEX "locales_source_textgroup_context_idx" ON "public"."locales_source" USING btree ("textgroup", "");

should be:

CREATE INDEX "locales_source_source_context_idx" ON "public"."locales_source" USING btree (substr(source, 1, 30), context);

CREATE INDEX "locales_source_textgroup_context_idx" ON "public"."locales_source" USING btree (textgroup, substr((context)::text, 1, 50));

[Jakub Vrána]

I've fixed the missing value after START. Indexes are more complicated, Adminer supports only basic column indexes.

[LacaK]

For indexes there is full definition of index in "indexdef" column of "pg_indexes" table.
Cann't you use it?
(for example when I export structure of Drupal tables I am not able to import them ...)

[Jakub Vrána]

Fixed by 9aaa4295.