Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group