because of the name you need to create a db view for it.
On Oct 4, 8:26 am, Johann Spies <[email protected]> wrote: > 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
