[SQL] How to find space occupied by postgres on harddisk

2008-07-07 Thread dipesh
Hello, Myself Dipesh Mistry from Ahmedabad India. I want to know that if i dump the 5GB sql file then how many space does postgres occupy on harddisk. Is there any calculation is available? Or any postgres command can give us this type of information? Thank you. -- With Warm Regards, Dipesh

[SQL] Error in restore the Database in Postgres

2008-04-17 Thread dipesh
written on each table. I use Postgres 8.1 version. Kindly Help me as early as possible. Or, give me another command. -- With Warm Regards, Dipesh Mistry Information Technology Dept. GaneshaSpeaks.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription

Re: [SQL] Delete with foreign keys

2008-02-22 Thread dipesh
that's just my novicity. I also wonder about getting fancy and ending up with SQL specific to a database; I don't have any plans to migrate, but I try to avoid branding my SQL. Hello, I am Dipesh Mistry from Ahmedabad-India. I have the solution for you. First drop the constraint on t