Any suggestions on how to get the count of all records that could be
returned
We use a window function to get the total # of records within each of
our paginated queries:
SELECT
...
,COUNT(*) OVER() fullRowCount
FROM ...
WHERE ...
ORDER BY ...
LIMIT ... OFFSET ...;
While there is a cost
Ack, I misspoke in my example last night about our use-case for
synonyms: we would ust them for trans-*schema* object referencing, not
trans-*database*.
Sorry about that--I fear that may have caused more confusion than necessary.
/m
--
Sent via pgsql-general mailing list (pgsql-general@post
I won't press the issue for Postgres any further, but I will attest that
synonyms work quite elegantly in Oracle, provide valuable functionality,
and do not generally sow confusion among skilled developers. It sounds
like the proposed "synonym" feature for Postgres perhaps had a different
inte
[ shrug... ] Beauty is in the eye of the beholder, I guess. To me the
search_path change seems like the natural way to do that, and flipping a
mess of synonyms the hack. What happens when you miss one synonym?
Changing Oracle synonyms is completely scriptable using the data
dictionary, so we
Here's a short overview of what Oracle synonyms provide:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/schema.htm#i5669
/m
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/6/10 4:09 PM, Tom Lane wrote:
Michael C Rosenstein writes:
What is "schema" in this context?
Oracle "schema" == Postgres "database": a collection of objects
(tables, functions, triggers, views, etc) owned by a user.
That seems like a pretty unlikely
What is "schema" in this context?
Oracle "schema" == Postgres "database": a collection of objects
(tables, functions, triggers, views, etc) owned by a user.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
SYNONYMS work for things that aren't a table.
The idea of synonyms for non-table things was pretty much rejected
already on the -hackers thread.
Again, in Oracle, we found synonyms on stored procedures and functions
as well as tables to be key.
/m
--
Sent via pgsql-general mailing list (
Synonyms would be very helpful to us. We just migrated our application
from Oracle, where we used synonyms to toggle between between two
schemas: one schema could be loaded with new data, while synonyms
pointed the web application to the live schema. Once the data load was
done, we switched th
Hello. We are new to Postgres, and are in the process of migrating our
project's app from Oracle.
I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
for >15 years (and love it!), but its support for Postgres 8.4 is weak
(e.g., missing many datatypes, no function-based indexe
10 matches
Mail list logo
