Re: Restoring from SQL dump

>
> Thanks, all. I did also try this from the Windows command prompt -- it gave
> me the standard error it gives when it has no idea what you're talking
> about: "'psql' is not recognized as an internal or external command,
> operable program or batch file." Any Windows PostgreSQL users present?

As I mentioned, give a fully qualified path name for psql.

Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253

On Fri, Oct 18, 2013 at 10:25 AM, Athanasios Kostopoulos <
athanasios(dot)kostopoulos(at)classmarkets(dot)com> wrote:

> 1) find where psql is located in your filesystem
> 2) add this to your %PATH%
>
>
> On Fri, Oct 18, 2013 at 4:22 PM, Erin Jonaitis <jonaitis(at)wisc(dot)edu> wrote:
>
>> Thanks, all. I did also try this from the Windows command prompt -- it
>> gave
>> me the standard error it gives when it has no idea what you're talking
>> about: "'psql' is not recognized as an internal or external command,
>> operable program or batch file." Any Windows PostgreSQL users present?
>>
>> Erin
>>
>> -----Original Message-----
>> From: pgsql-novice-owner(at)postgresql(dot)org
>> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of David Johnston
>> Sent: Friday, October 18, 2013 9:19 AM
>> To: pgsql-novice(at)postgresql(dot)org
>> Subject: Re: [NOVICE] Restoring from SQL dump
>>
>> Erin Jonaitis wrote
>> > 3) Now I have a psql window open with the following prompt:
>> > dbname=#
>> >
>> > 4) I tried typing the following:
>> > psql -f M:\LongitudinalDB\backups\2013.10.02\uw.sql
>> > and got the following error:
>> > Invalid command \LongitudinalDB. Try \? For help.
>>
>> #3 - you are now in psql
>> #4 - you are acting as if you are sitting at your OS shell prompt here
>>
>> Either learn the psql to run an external file or get back to your OS shell
>> prompt and run the psql command from there.
>>
>> Not sure why you did't get more errors.
>>
>> Yes, backslashes inside psql denote the intent to use a special command
>> which "Long..." is not.
>>
>> David J.
>>
>>
>>
>>
>> --
>> View this message in context:
>>
>> http://postgresql.1045698.n5.nabble.com/Restoring-from-SQL-dump-tp5775028p57
>> 75031.html<http://postgresql.1045698.n5.nabble.com/Restoring-from-SQL-dump-tp5775028p5775031.html>
>> Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
>>
>>
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org) To make
>> changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>>
>>
>>
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>>
>
>
> classmarkets GmbH | Schumannstraße 6 | 10117 Berlin | Deutschland
> Tel: +49 (0)30 56 59 001-0 | Fax: +49 (0)30 56 59 001-99 |
> www.classmarkets.com
>
> Amtsgericht Charlottenburg HRB 111815 B | USt-IdNr. DE 260731582
> Geschäftsführer: Veit Mürz, Fabian Ströhle
>
> Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sie darf
> ausschließlich durch den vorgesehenen Empfänger und Adressaten gelesen,
> kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich
> erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon
> unverzüglich zu informieren und die Nachricht zu löschen. Jede unerlaubte
> Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollständig
> oder teilweise, ist unzulässig. Bitte beachten Sie, dass E-Mail-Nachrichten
> an den Absender nicht für fristgebundene Mitteilungen geeignet sind.
> Fristgebundene Mitteilungen sind daher ausschließlich per Post oder per
> Telefax zu übersenden.
>