Richard, So the SQL file's name is bioseqdbmart.sql, the source is bioseqdb and the mart or target is bioseqdbmart. OK, so:
psql bioseqdbmart postgres < bioseqdbmart.sql might not work, I should be logged in. Let's log in... Hmm. I see: bioseqdbmart=# \i bioseqdbmart.sql psql:bioseqdbmart.sql:1: ERROR: schema "bioseqdbmart" already exists SET psql:bioseqdbmart.sql:6: ERROR: relation "public.bioentry" does not exist SET psql:bioseqdbmart.sql:9: ERROR: relation "bioseqdbmart.temp__1" does not exist SET ...and more errors. "public.bioentry" is troubling, it should be "public.bioseqdb.bioentry" or "bioseqdb.bioentry", I think. That error comes from this: bioseqdbmart=# create table bioseqdbmart.TEMP__1 as select a.accession as accession,a.biodatabase_id as biodatabase_id, bioseqdbmart-# a.bioentry_id as bioentry_id_key,a.description as description,a.division as division,a.identifier as bioseqdbmart-# identifier,a.name as name,a.taxon_id as taxon_id,a.version as version,b.authority as authority, bioseqdbmart-# b.description as description_biodatabase,b.name as name_biodatabase from public.bioentry as a left join bioseqdbmart-# public.biodatabase as b on a.biodatabase_id=b.biodatabase_id; ERROR: relation "public.bioentry" does not exist bioseqdbmart=# Brian O. On 5/24/07 10:36 AM, "Richard Holland" <[EMAIL PROTECTED]> wrote: > run whilst logged in as the target schema owner.