Selecting Schema when using postgres

[peerjakobsen]

Hi,

I can only get MyMeta to show me tables from the public schema in postgres. It would be nice to be able to pass the schema name to MyMeta so that tables not in the public schema could be processed.

For example, instead of :

Code: Select all

Sub bindTables(sDatabase)
   Set db = MyMeta.Databases(sDatabase)
   
   lstTables.BindData(db.Tables)
End Sub

Have something like this:

Code: Select all

Sub bindTables(sDatabase, sSchema)
   Set db = MyMeta.Databases(sDatabase, sSchema)
   
   lstTables.BindData(db.Tables)
End Sub

Thanks

[mike.griffin]

Are you selecting Postgre SQL 8+ in the dropdown?

[peerjakobsen]

Yes I am.

Should that give me some kind of extra option for the Schema?

[mike.griffin]

Oh, I see the issue. MyMeta (the meta data provider) has an issue dealing with Schema's. I don't think there is a work around?

[justin.greenwood]

There is always a work around - but it may get ugly. :S

[cgriffo]

I am having the same trouble with only being able to get tables from one schema. I can choose different schemas by setting the search path in Postgres, but it would be really nice to be able get tables from more than one. Is there a way to get tables from multiple schemas.

Thanks,
Craig