Server properties
Property Value
Description  LOCALHOST
  Service
  Hostname  localhost
  Host Address
  Port  5432
  Encryption  SSL encrypted
  SSL Certificate File
  SSL Key File
  SSL Root Certificate File
  SSL Certificate Revocation List
  Maintenance database  postgres
  Username  postgres
  Store password?  Yes
  Restore environment?  Yes
  Version string  PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit
  Version number  9.0
  Last system OID  11866
  Connected?  Yes
  Up since  08/19/2011 07:28:54 AM
  Configuration loaded since  08/19/2011 07:28:53 AM
  Autovacuum  running
  In recovery  no
  Last XLOG receive location
  Last XLOG replay location


Schema properties
Schema			Owner		Comment
"VK2-'.'vk2"	postgres
VK1				postgres
public			postgres	standard public schema
vk_normal		postgres



Schema properties
Property Value
Name  public
OID  2200
Owner  postgres
ACL  {postgres=UC/postgres,=UC/postgres}
Default table ACL
Default sequence ACL
Default function ACL
System schema?  No
Comment  standard public schema

   
-- Schema: public
-- DROP SCHEMA public;
CREATE SCHEMA public
  AUTHORIZATION postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public
  IS 'standard public schema';


Tables
Table			Owner			Comment
VK_empty	postgres
vk1				vlada
vk2				vlada



-- Table: "VK_empty"
-- DROP TABLE "VK_empty";
CREATE TABLE "VK_empty"
(
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "VK_empty"
  OWNER TO postgres;

-- Table: vk1
-- DROP TABLE vk1;
CREATE TABLE vk1
(
  id bigint NOT NULL DEFAULT nextval('id_vk1'::regclass),
  bool1 boolean NOT NULL DEFAULT true,
  ts timestamp without time zone NOT NULL DEFAULT now(),
  host inet NOT NULL DEFAULT inet_client_addr(),
  bool2 boolean NOT NULL DEFAULT true,
  CONSTRAINT pkey PRIMARY KEY (id ),
  CONSTRAINT u1 UNIQUE (host , id )
)
WITH (
  OIDS=FALSE
);
ALTER TABLE vk1
  OWNER TO vlada;
GRANT ALL ON TABLE vk1 TO vlada;
GRANT ALL ON TABLE vk1 TO public;


-- Table: vk2
-- DROP TABLE vk2;
CREATE TABLE vk2
(
  "ID" bigint NOT NULL DEFAULT nextval('"""id''.''vk2"""'::regclass),
  "CV1" character varying NOT NULL,
  "Bool1" boolean NOT NULL DEFAULT true,
  "TS" timestamp without time zone NOT NULL DEFAULT now(),
  "Host" inet NOT NULL DEFAULT inet_client_addr(),
  "Int1" integer,
  CONSTRAINT gk_vrsta_promene_pkey PRIMARY KEY ("ID" ),
  CONSTRAINT "U1" UNIQUE ("Int1" , "ID" )
)
WITH (
  OIDS=FALSE
);
ALTER TABLE vk2
  OWNER TO vlada;
GRANT ALL ON TABLE vk2 TO vlada;
GRANT ALL ON TABLE vk2 TO public;


Sequences
Sequence			Owner 	Comment
"id'.'vk2"  	vlada
id_vk1				vlada


-- Sequence: id_vk1
-- DROP SEQUENCE id_vk1;
CREATE SEQUENCE id_vk1
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 74
  CACHE 1;
ALTER TABLE id_vk1
  OWNER TO vlada;
GRANT ALL ON TABLE id_vk1 TO vlada;
GRANT ALL ON TABLE id_vk1 TO public;


-- Sequence: """id'.'vk2"""
-- DROP SEQUENCE """id'.'vk2""";
CREATE SEQUENCE """id'.'vk2"""
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 22
  CACHE 1;
ALTER TABLE """id'.'vk2"""
  OWNER TO vlada;
GRANT ALL ON TABLE """id'.'vk2""" TO vlada;
GRANT ALL ON TABLE """id'.'vk2""" TO public;



1.  copy public						into "VK2-'.'vk2"	==> OK 3
2.  copy "VK2-'.'vk2"				into "VK2-'.'vk2"	==> OK 6
3.  copy public						into VK1			==> OK 3
4.  copy public						into public			==> OK 6
5.  copy public						into vk_normal		==> OK 6
6.  copy VK1						into public			==> OK 9
7.  copy VK1						into vk_normal		==> OK 9
8.  copy vk_normal					into public			==> OK 18

9.  copy public.vk2_copy_1_2		into "VK2-'.'vk2"	==> OK 7
10. copy "VK2-'.'vk2".vk2_copy_1_2	into "VK2-'.'vk2"	==> OK 8
11. copy public.vk2_copy_1_2		into VK1			==> OK 4
12. copy public.vk2_copy_1_2		into public			==> OK 19
13. copy public.vk2_copy_1_2		into vk_normal		==> OK 10
14. copy VK1.vk2_copy_1_2			into public			==> OK 20
15. copy VK1.vk2_copy_1_2			into vk_normal		==> OK 11
16. copy vk_normal.vk2_copy_1_2		into public			==> OK 21

17. copy from the selection list:
Server Groups
	ISPP							group1
		Dragan Ciric				server
			ispp-pprostor-beograd	db
				budzet_2011			schema
					ispp_brojac		table
					ispp_nalog
					ispp_promene
				direkcija_2005
					ispp_nalog
					ispp_promene
		ispp-pionir-test
			ispp-pprostor-test
				direkcija_2005
					ispp_nalog
					ispp_promene
	Servers							group2
		LOCALHOST					server
			ispp-pprostor-beograd	db
				budzet_2010			schema
					ispp_brojac		table
					ispp_nalog
					ispp_promene
				direkcija_2005
					ispp_nalog
					ispp_promene

into "VK2-'.'vk2" ==> OK 20