Re: Restoring SQL Databse for use in PostgreSQL.

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Restoring SQL Databse for use in PostgreSQL.
Дата
Msg-id 20060130173602.GA18990@wolff.to
обсуждение исходный текст
Ответ на Restoring SQL Databse for use in PostgreSQL.  (Dhivya <dhivyacando@yahoo.co.in>)
Список pgsql-novice
On Fri, Jan 27, 2006 at 10:17:38 +0000,
  Dhivya <dhivyacando@yahoo.co.in> wrote:
>   Hello,
>
>       I am a new user to PostgreSQL.
>   I need to use the "Northwind" database in SQL.
>   I tried to take a backup of that database.
>   And tried to restore the backup in PostgreSQL. But i could not do that.

How did you try to do that? What happened when you did?

>   And also when i try to display the columns of a table(in PostgreSQL) in a datagrid in the front end, the columns
appearsin random order(rather than the order in table (or) sorted). 

If you want the output ordered, you need to have an ORDER BY clause in your
SELECT statement saying what to order by.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help, 400 million rows, query slow, I stopped after 5 days
Следующее
От: "Christian Hofmann"
Дата:
Сообщение: Re: Help, 400 million rows, query slow, I stopped after 5 days