I think I already know the answer to this one, but I'm hoping I missed something. Is there anyway to programmatically create a backlink from a table to a database? The table already exists in the database, so ADD TABLE isn't going to work.
Just to give some background, I've got a web page that uses data that has been compiled the night before. Every night around 11:30pm the information is transferred to our web server (ie. just using COPY). Now one of those tables copied over needs to be part of a database (I've got a bunch of views based on the table). The way it's looking right now, I'll have to remove the table from the database, copy over the new table, ADD TABLE to get it back, then manually recreate all the views. A nice one line command would be preferred ;-)