Re: Restoring SQL Databse for use in PostgreSQL.

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dhivya <dhivyacando(at)yahoo(dot)co(dot)in>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Restoring SQL Databse for use in PostgreSQL.
Date: 2006-01-30 17:36:02
Message-ID: 20060130173602.GA18990@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Jan 27, 2006 at 10:17:38 +0000,
Dhivya <dhivyacando(at)yahoo(dot)co(dot)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 appears in 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Christian Hofmann 2006-01-30 17:44:57 Re: Help, 400 million rows, query slow, I stopped after 5 days
Previous Message Tom Lane 2006-01-30 16:28:44 Re: Help, 400 million rows, query slow, I stopped after 5 days