Search Postgresql Archives

Solution for Synonyms

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



We are in the process of moving from Oracle to PostgreSQL.  We use a stored
procedure to populate some reporting tables once an hour.  There are two
sets of these tables, set A and set B.  We use synonyms to point to the
“active” set of tables at any given time.  

The procedure works like this:

1. If set A tables are “active” truncate set B tables or if set A tables are
“active” truncate set B tables.
2. Populate set B tables.
3. Set synonyms to point to set B tables.

How might I accomplish the same thing in PostgreSQL?

Thanks,
Mark



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Solution-for-Synonyms-tp5779816.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux