Re: Psql Question

Поиск
Список
Период
Сортировка
От He Weiping (Laser Henry)
Тема Re: Psql Question
Дата
Msg-id 39C6CE1C.AF5D4BDA@zhengmai.com.cn
обсуждение исходный текст
Ответ на Can't connect to 6.5.2 server with 7.0.2 client  (Forest Wilkinson <fspam@home.com>)
Список pgsql-general
Danny wrote:

> - Hello
> - I had previous experience with Access and MySQL.
>
> -Situation
>
> - I am trying to create the equvilant of the following which is a mysql
> command.
>
> - Queston
> - But I cannot figure out how to do this is postgresql
>
> "mysql -u root -p mydb < mydb.dump"
>

I think:
psql -u somebody -d template1 < yourdb.dump
would work.

>
> - I was trying to create a test database using the following commands using a
> very cliche example . This command works on mySQL and should be part of the
> ANSI SQL standard
>
> mydb=# INSERT INTO Customer (Customer_ID,Customer_Name,Customer_Address,Customer_Email)
> mydb-# VALUES ('1','Danny Ho','99 Second Ave, Kingswood','dannyh@customer.com'),
> mydb-# ('2','Randal Handel','54 Oxford Road, Cambridge','randalh@customer.com')
> mydb-# ;
>

you can't insert two values at the same time, you would have to use two INSERT.

>
> -and I get the following errors :
>
> ERROR:  parser: parse error at or near ","
>
> Looking forwrd to your feedback.,
>
> dannyh
>
> dannyH@dix.com.au


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

Предыдущее
От: Danny
Дата:
Сообщение: Psql Question
Следующее
От: Victor Sudakov
Дата:
Сообщение: Permissions on databases (not on tables)