Re: Restoring from SQL dump

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: Restoring from SQL dump
Дата
Msg-id 1382105930381-5775031.post@n5.nabble.com
обсуждение исходный текст
Ответ на Restoring from SQL dump  (Erin Jonaitis <jonaitis@wisc.edu>)
Ответы Re: Restoring from SQL dump  (Erin Jonaitis <jonaitis@wisc.edu>)
Список pgsql-novice
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-tp5775028p5775031.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


В списке pgsql-novice по дате отправления:

Предыдущее
От: Payal Singh
Дата:
Сообщение: Re: Restoring from SQL dump
Следующее
От: Ken Benson
Дата:
Сообщение: Re: Restoring from SQL dump