Re: New from mssql. Help please

From: "hendro" <hendro(at)myrealbox(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: New from mssql. Help please
Date: 2004-05-22 10:29:10
Message-ID: 000f01c43fe7$a1037490$1548053d@HERCULES
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I've tried it, but nothing happen, just display some text says "less:not
found" What's wrong?

I use version 7.3.1.

PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
20020927 (prerelease)

Should I upgrade?

Thanks.

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org>
mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Joe Erickson

Sent: Jumat, 21 Mei 2004 19:40

To: hendro; pgsql-novice(at)postgresql(dot)org

Subject: Re: [NOVICE] New from mssql. Help please

In psql, you can do a \da to list aggregate functions, like max() and
sum(), and \df to list functions. This is probably not the best way to
learn the functions though. A good web site that lists functions is
<http://www.postgresql.org/docs/7.4/interactive/functions.html>
http://www.postgresql.org/docs/7.4/interactive/functions.html

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org]On>
mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of hendro

Sent: Friday, May 21, 2004 3:50 AM

To: pgsql-novice(at)postgresql(dot)org

Subject: [NOVICE] New from mssql. Help please

Hi,

I'm new here.

My major problem is working with functions. (previously I use SQL

Server)

For instance, I haven't find a way to alter a function, or to view
function list. (any keystroke like \d that will display functions ?) Can
anybody suggest a nice place to start? An URL perhaps?

BTW, \? returns nothing in psql. How come?

Thanks

Hendro

---------------------------(end of broadcast)---------------------------

TIP 5: Have you checked our extensive FAQ?

<http://www.postgresql.org/docs/faqs/FAQ.html>
http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister command

(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

I've tried it, but nothing happen, just display some text says "less:not
found" What's wrong? My use version 7.3.1. Should I upgrade?

version

------------------------------------------------------------------------
-----------------

PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
20020927 (prerelease)

Thanks.

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org>
mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Joe Erickson

Sent: Jumat, 21 Mei 2004 19:40

To: hendro; pgsql-novice(at)postgresql(dot)org

Subject: Re: [NOVICE] New from mssql. Help please

In psql, you can do a \da to list aggregate functions, like max() and
sum(), and \df to list functions. This is probably not the best way to
learn the functions though. A good web site that lists functions is
<http://www.postgresql.org/docs/7.4/interactive/functions.html>
http://www.postgresql.org/docs/7.4/interactive/functions.html

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org]On>
mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of hendro

Sent: Friday, May 21, 2004 3:50 AM

To: pgsql-novice(at)postgresql(dot)org

Subject: [NOVICE] New from mssql. Help please

Hi,

I'm new here.

My major problem is working with functions. (previously I use SQL

Server)

For instance, I haven't find a way to alter a function, or to view
function list. (any keystroke like \d that will display functions ?) Can
anybody suggest a nice place to start? An URL perhaps?

BTW, \? returns nothing in psql. How come?

Thanks

Hendro

---------------------------(end of broadcast)---------------------------

TIP 5: Have you checked our extensive FAQ?

<http://www.postgresql.org/docs/faqs/FAQ.html>
http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister command

(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rory Campbell-Lange 2004-05-22 19:27:25 Re: New from mssql. Help please
Previous Message Jeffrey Melloy 2004-05-22 02:52:48 Re: Set search_path