Hello,
May I know how to generate drop table cascade when pg_dump a schema please?
E.g.,
pg_dump -h db_server -E UTF8 -n schema_name -U schema_owner --clean
-d db_name >! ~/a.dmp
In a.dmp, I'd like to get:
drop table t1 cascade;
drop table t2 cascade;
... ...
Only dropping constraints wi
On 01/08/2013 07:08 AM, Edward W. Rouse wrote:
We have a database that was updated from 7.4.1 to 9.1.3. I've gotten
everything working, but now it seems that the users and groups weren't
restored. Probably because they weren't backed up. Is there a way to dump
just the users and groups, plus the
We have a database that was updated from 7.4.1 to 9.1.3. I've gotten
everything working, but now it seems that the users and groups weren't
restored. Probably because they weren't backed up. Is there a way to dump
just the users and groups, plus the passwords and permissions, and restore
them witho
On Tue, Jan 8, 2013 at 2:34 PM, Emi Lu wrote:
> Hello Thomas,
>
>
>>> Thanks a lot! I just noticed that my postgresql is 8.3(unnest
>>> function is not there by default). Is there a way that I could
>>> download and load only this function from somewhere?
>>
>>
>>
>> Are you aware that 8.3 will be
On Tue, Jan 08, 2013 at 09:34:24AM -0500, Emi Lu wrote:
> Hello Thomas,
>
> >>Thanks a lot! I just noticed that my postgresql is 8.3(unnest
> >>function is not there by default). Is there a way that I could
> >>download and load only this function from somewhere?
> >
> >
> >Are you aware that 8.3
Hello Thomas,
Thanks a lot! I just noticed that my postgresql is 8.3(unnest
function is not there by default). Is there a way that I could
download and load only this function from somewhere?
Are you aware that 8.3 will be de-suppported as of next month?
You should really think about an upgr