I'd also wonder if it shows up when he does -N public (exclude public schema)?
On Mon, Jun 25, 2012 at 12:37 AM, Anthony Bull wrote:
> Out of curiosity, what happens if you dump that database without specifying
> a schema - do you get all 708 tables?
>
>
> On Fri, Jun 22, 2012 at 8:45 PM, Stefan
Out of curiosity, what happens if you dump that database without specifying
a schema - do you get all 708 tables?
On Fri, Jun 22, 2012 at 8:45 PM, Stefan Schwarzer wrote:
> Hi there,
>
> I am pg_dump-ing all tables from schema public on the server
>
> /usr/local/pgsql/bin/pg_dump -U user m
>> Hi there,
>>
>> I am pg_dump-ing all tables from schema public on the server
>>
>> /usr/local/pgsql/bin/pg_dump -U user my_database --schema=public
>> --encoding=UTF-8 > dump.sql
>>
>> and re-loading it via psql on my local machine.
>>
>> But instead of having 708 tables as on the ser
On 22 June 2012 10:45, Stefan Schwarzer wrote:
> Hi there,
>
> I am pg_dump-ing all tables from schema public on the server
>
> /usr/local/pgsql/bin/pg_dump -U user my_database --schema=public
> --encoding=UTF-8 > dump.sql
>
> and re-loading it via psql on my local machine.
>
> But instead
Hi there,
I am pg_dump-ing all tables from schema public on the server
/usr/local/pgsql/bin/pg_dump -U user my_database --schema=public
--encoding=UTF-8 > dump.sql
and re-loading it via psql on my local machine.
But instead of having 708 tables as on the server, I end up with only 570