Обсуждение: HELP FOR LOADING a .psql file (same question again but explained neatly)
hello i am new to psql or any database stuff.
i have downloaded an .psql file from internet and wish to open it and see the data inside.
i am working on windows xp and have installed the software successfully.
please help i am my wits end.
it is huge file 800mb
and is supposed to contain a database.
the question is how to load it?
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to be running a PostgreSQL server to install ConceptNet 3.
how do i load it?
thanks a lot
--
akshay uday bhat.
t.y.c.e.
department of chemical engineering
university institute of chemical technology
mumbai India
On action alone be thy interest,
Never on its fruits.
Let not the fruits of action be thy motive,
Nor be thy attachment to inaction.
Ask and it shall be given to you; seek and you shall find; knock and it shall be opened to you
i have downloaded an .psql file from internet and wish to open it and see the data inside.
i am working on windows xp and have installed the software successfully.
please help i am my wits end.
it is huge file 800mb
and is supposed to contain a database.
the question is how to load it?
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to be running a PostgreSQL server to install ConceptNet 3.
how do i load it?
thanks a lot
--
akshay uday bhat.
t.y.c.e.
department of chemical engineering
university institute of chemical technology
mumbai India
On action alone be thy interest,
Never on its fruits.
Let not the fruits of action be thy motive,
Nor be thy attachment to inaction.
Ask and it shall be given to you; seek and you shall find; knock and it shall be opened to you
Re: HELP FOR LOADING a .psql file (same question again but explained neatly)
От
"Ranbeer Makin"
Дата:
On the postgres command prompt you can use "/i filename" ... try if it works....
Cheers
Cheers
On Thu, Feb 28, 2008 at 9:07 AM, akshay bhat <akshayubhat@gmail.com> wrote:
hello i am new to psql or any database stuff.
i have downloaded an .psql file from internet and wish to open it and see the data inside.
i am working on windows xp and have installed the software successfully.
please help i am my wits end.
it is huge file 800mb
and is supposed to contain a database.
the question is how to load it?
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to be running a PostgreSQL server to install ConceptNet 3.
how do i load it?
thanks a lot
--
akshay uday bhat.
t.y.c.e.
department of chemical engineering
university institute of chemical technology
mumbai India
On action alone be thy interest,
Never on its fruits.
Let not the fruits of action be thy motive,
Nor be thy attachment to inaction.
Ask and it shall be given to you; seek and you shall find; knock and it shall be opened to you
Re: HELP FOR LOADING a .psql file (same question again but explained neatly)
От
Richard Huxton
Дата:
akshay bhat wrote: > hello i am new to psql or any database stuff. > i have downloaded an .psql file from internet and wish to open it and see > the data inside. > i am working on windows xp and have installed the software successfully. > please help i am my wits end. So what have you tried so far? What went wrong? What error messages did you get? Does this ".psql" file create the database or does it expect you to load it into an existing database? -- Richard Huxton Archonet Ltd
Re: HELP FOR LOADING a .psql file (same question again but explained neatly)
От
Colin Wetherbee
Дата:
akshay bhat wrote: > hello i am new to psql or any database stuff. > i have downloaded an .psql file from internet and wish to open it and > see the data inside. > i am working on windows xp and have installed the software successfully. > please help i am my wits end. > it is huge file 800mb > and is supposed to contain a database. > the question is how to load it? > > it was downloaded from this link http://conceptnet.media.mit.edu/ > the description says > The ConceptNet 3 database > <http://conceptnet.media.mit.edu/conceptnet-2007-09-25.tar.gz>, as a > PostgreSQL input file. You will need to be running a PostgreSQL server > to install ConceptNet 3. > > how do i load it? It was a 40-second download, so I grabbed it. It looks like you need to create a database and then load this .psql file into it. It contains all your CREATE TABLE statements and everything else. Once you get your database set up appropriately, this command should do the trick: psql -d <your_database_name> -f conceptnet-2007-09-25.psql Colin