I am working with a database set up by someone else. They set it up so that
most tables are in the public schema, but they also have a reports schema;
database.public.tables and database.reports.tables.
If I do a pg_dump of the database, I only get the public schema. If I do a
dump with --schema=r
On 02/16/2012 10:59 AM, Edward W. Rouse wrote:
I am working with a database set up by someone else. They set it up so that
most tables are in the public schema, but they also have a reports schema;
database.public.tables and database.reports.tables.
If I do a pg_dump of the database, I only get
To answer the second question first, yes; both as the same user.
pg_dump -v -f $bkfile -F c -U $USER $DATABASE
> -Original Message-
> From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
> Sent: Thursday, February 16, 2012 2:22 PM
> To: Edward W. Rouse
> Cc: pgsql-sql@postgresql.org
> S
On 02/16/2012 11:31 AM, Edward W. Rouse wrote:
To answer the second question first, yes; both as the same user.
pg_dump -v -f $bkfile -F c -U $USER $DATABASE
So how are you determining that only the public schema is being dumped?
One thing to check is the search_path setting in postgresql.con
Well, when I do a restore using the created file, reports isn't there. i.e.
the select from reports.table gives an error and, from psql, \l doesn't list
it and \dn doesn't show it. But that all does work on the original database.
> -Original Message-
> From: pgsql-sql-ow...@postgresql.org
On 02/16/2012 12:17 PM, Edward W. Rouse wrote:
Well, when I do a restore using the created file, reports isn't there. i.e.
the select from reports.table gives an error and, from psql, \l doesn't list
it and \dn doesn't show it. But that all does work on the original database.
What is the error
Hello all,
I am trying to use this query in a toy database with customers and orders in
order to understand the capabilities of partitioning. In plain english what
I want to do is to select the orders of each customer and return only 3 of
those orders.
The query I am using is this:
select c_cu
On Feb 16, 2012, at 20:01, vpapavas wrote:
> Hello all,
>
> I am trying to use this query in a toy database with customers and orders in
> order to understand the capabilities of partitioning. In plain english what
> I want to do is to select the orders of each customer and return only 3 of
> t
