Re: Restoring SQL Databse for use in PostgreSQL. - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Restoring SQL Databse for use in PostgreSQL.
Date
Msg-id 20060130173602.GA18990@wolff.to
Whole thread Raw
In response to Restoring SQL Databse for use in PostgreSQL.  (Dhivya <dhivyacando@yahoo.co.in>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days
Next
From: "Christian Hofmann"
Date:
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days