Cloning schemas - Mailing list pgsql-general

From Łukasz Jarych
Subject Cloning schemas
Date
Msg-id CAGv31ofHAE49iTQ4_Q_AiTduoVscQWXKfZanYU0yQP8HyxPJvQ@mail.gmail.com
Whole thread Raw
Responses Re: Cloning schemas
List pgsql-general
Hi,

i am trying to use postgresql clone schema function:


I created function clone_schema in public schema:

image.png


I am trying to use :

"select * from clone_schema('public','Version8',true) but i am getting error:

"Column "max_value" does not exist. 
LINE 1: SELECT last_value, max_value, start_value, increment_by, min...
HINT: Maybe you wanted to point to column " "audit_sq.last_value"?
QUERY: SELECT last_value, max_value, start_value, increment_by, min_value, cache_value, log_cnt, is_cycled, is_called FROM public.audit_sq;

CONTEXT: function PL/pgSQL clone_schema(text,text,boolean), row 66 in EXECUTE
SQL state: 42703
Can anyone help?

Best,
Jacek


Attachment

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Call for Papers - PGConf.ASIA 2018
Next
From: Łukasz Jarych
Date:
Subject: Re: Cloning schemas