X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0B5E79DCCB7 for ; Wed, 1 Mar 2006 05:15:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36146-05 for ; Wed, 1 Mar 2006 05:15:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id 7004D9DCCB4 for ; Wed, 1 Mar 2006 05:15:20 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so91090nzp for ; Wed, 01 Mar 2006 01:15:23 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=IyK5yGsbEQPFhXMfKRMZoAFS0shGo3ZTy2KRWORGjHn4cR3qbVufPSeqsVsgj6AndVBq1vxh/1tOOHT7hTTiFAjUAwuKhwfIXGHqr4N2i4zm0w/IOaQ4U29dOwCCW9xyHkks3ceGwICcKYuMJSe6Z4SiSZk75EAIKM806HZPnYs= Received: by 10.37.15.61 with SMTP id s61mr4438324nzi; Wed, 01 Mar 2006 01:15:22 -0800 (PST) Received: by 10.36.72.10 with HTTP; Wed, 1 Mar 2006 01:15:22 -0800 (PST) Message-ID: <674d1f8a0603010115h79866cc8vcb5982065cd91ba5@mail.gmail.com> Date: Wed, 1 Mar 2006 14:45:22 +0530 From: "Gourish Singbal" To: "E.Karystinakis@bradford.ac.uk" Subject: Re: Database information Cc: pgsql-admin@postgresql.org In-Reply-To: <1141056432.440323b0c89b7@webmail6.brad.ac.uk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16553_12597569.1141204522814" References: <1141056432.440323b0c89b7@webmail6.brad.ac.uk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.117, HTML_MESSAGE=0.001] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/1 X-Sequence-Number: 20758 ------=_Part_16553_12597569.1141204522814 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Use the pg_dump utility in postgresql. 1. to export the database data use . /usr/local/pgsql/bin/pg_dump [database_name] > filename.dat 2. to export only the schema of the database . /usr/local/pgsql/bin/pg_dump -s [database_name] > schema_filename.sql NOTE: /usr/local/pgsql/bin/pg_dump --help is ur friend. On 2/27/06, E.Karystinakis@bradford.ac.uk wrote: > > Hello, > > I am a student at the university of Bradfordat the department of > Computing. In > the labs we use postgeSQL. If it is possible can you please inform me how > I can > create .dat files with the information of the tables of the existing > database > and a .sql file which will have the tables that are created? I would > appreciate > your help. > > Thank you in advance, > > Karystinakis Evangelos > > > ------------------------------------------------------------ > This mail sent through IMP: http://webmail.brad.ac.uk > To report misuse from this email address forward the message > and full headers to misuse@bradford.ac.uk > ------------------------------------------------------------ > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Best, Gourish Singbal ------=_Part_16553_12597569.1141204522814 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
Use the pg_dump utility in postgresql.
1. to export the database data use .
/usr/local/pgsql/bin/pg_dump [database_name] > filename.dat
 
2. to export only the schema of the database .
/usr/local/pgsql/bin= /pg_dump -s [database_name] > schema_filename.sql
 
NOTE:
/usr/local/pgsql/bin/pg_dump --help
is ur friend.
 
 
On 2/27/06, = E.Karystinakis@bradford.ac= .uk <E.Karystin= akis@bradford.ac.uk > wrote:
Hello,

I am a student at = the university of Bradfordat the department of Computing. In
the labs we= use postgeSQL. If it is possible can you please inform me how I can
create .dat files with the information of the tables of the existing da= tabase
and a .sql file which will have the tables that are created? I wo= uld appreciate
your help.

Thank you in advance,

Karystinak= is Evangelos


------------------------------------------------------------This mail sent through IMP: http://w= ebmail.brad.ac.uk
To report misuse from this email address forward t= he message
and full headers to misuse@bra= dford.ac.uk
--------------------------------------------------------= ----


---------------------------(end of broadcast)--------------= -------------
TIP 5: don't forget to increase your free space map settings



--
Best,
Gourish Singbal=20 ------=_Part_16553_12597569.1141204522814--