I want to use a legacy database. In Postgresql I access it as A.b.c where A is the database, b is the schema and c is where the tables are.sql
Here is an example of the sql that created one of the original tables: CREATE TABLE kbase.institution ( id integer NOT NULL, "name" character varying(50), notes text, higher_education smallint, university smallint, technikon smallint, government integer, ngo integer, CONSTRAINT institution_pkey PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE kbase.institution OWNER TO js; In this case I am connected to database africaDB. Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godliness through the full knowledge of the one who called us by his own glory and excellence. 2 Pet. 1:2b,3a
