[GENERAL] FW: information about tables via psql

ournalled, etc. In Ingres in > order to see that information I use commands 'help ' and > more detailed version 'help table '. Is there any postgres > equivalent of these commands? > > With psql I used '\d ' and '\d+ showed me

Re: [GENERAL] setting Postgres client

YES! Done - my listen addresses was the default. Thanks Richard! Nina -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: September 19, 2008 11:57 To: Markova, Nina Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] setting Postgres client Markova, Nina wrote

Re: [GENERAL] setting Postgres client

ives_count = 0 # TCP_KEEPCNT; # 0 selects the system default Should I change something here? Nina -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: September 19, 2008 10:15 To: Markova, Nina Subject: Re: [GENERA

[GENERAL] setting Postgres client

My message didn't get through the 1st time. -Original Message- From: Markova, Nina Sent: September 17, 2008 17:33 To: pgsql-general@postgresql.org Subject: Help on setting Postgres client I have setup a Postgres server (8.2.4) on Solaris 10, for now in the global zone, wi

[GENERAL] Psql command for rowcount

postgres public | opslog2actionlog | table | postgres public | participation | table | postgres public | pazdesc | table | postgres public | pazvals | table | postgres public | snetsta | table | postgres (15 rows) Thanks in advance, Nina

Re: [GENERAL] FW: How to upload data to postgres

Adrian, The trick seems to work. Thanks! Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 10, 2008 11:58 To: Markova, Nina Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED] Subject: RE: [GENERAL] FW: How to upload data to postgres

Re: [GENERAL] FW: How to upload data to postgres

I also plan to try to export data in XML format (from Ingres) and import it to Postgres. I didn't find any utility for importing XML data into Postgres. Or just looking at the wrong document? I run Postgres 8.2.4 Thanks, Nina -Original Message- From: Adrian Klaver [mailto:[

Re: [GENERAL] FW: How to upload data to postgres

| not null elev| double precision | not null default 0 regist_code | character(1) | not null default ' '::bpchar Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 9, 2008 22:43 To: pgsql-general@postgresql.org Cc: Marko

[GENERAL] FW: How to upload data to postgres

the Postgres documentation I only saw how to create an index with a specific structure. In Ingres: modify site to isam unique on sta, ondate (means structure isam, primary key is on 2 fields - sta and ondate) Thanks in advance, Nina > __ > F

[GENERAL] How to upload data to postgres

Hi again, I need to load data from Ingres database to Postgres database. What's the easiest way? Thanks, Nina

[GENERAL] 3 postgres processes

4924 /pg_data 543200131 Thanks, -'\/\/\/`v^v^v^v^v^v^v Nina Markova, Database Analyst/ Analyst de base de données (613) 992-3753 facsimile / télécopieur (613) 992-8836 [

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

Thanks all. I have the /usr/lib/libkrb5.so.1 but somehow the checkinstall script can't find it (it is s10u4). As a result in the non-global zone these and are missing, they exist in the global zone though. Nina -Original Message- From: James Gates [mailto:[EMAIL PROTECTED]

[GENERAL] Postgres in a solaris zone - patch 125077-02 needed

hanks, Nina

Re: [GENERAL] How to check what is current postgres version

Thanks From: justin [mailto:[EMAIL PROTECTED] Sent: September 8, 2008 13:54 To: Markova, Nina Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to check what is current postgres version select version() Markova, Nina wrote: Hi

[GENERAL] How to check what is current postgres version

Hi, Is there any way to check the exact current version without issuing 'psql' command? Say, 8.2.1 or 8.2.9? Thanks, Nina

[GENERAL] Postgres in a solaris zone

Hi, Anybody has an experience in running postgres database server from a solaris zone? Do you see any problems with such a setup? Any traps? Thanks, -'\/\/\/`v^v^v^v^v^v^v Nina Markova, Database An

[GENERAL] New to postgres -' how to' tips needed

mple. Any suggestions comments are welcome. Thanks, -'\/\/\/`v^v^v^v^v^v^v---- Nina Markova, Database Analyst/ Analyst de base de données (613) 992-3753 facsimile / télécopieur (613)

[GENERAL] "psql -At -F" export column from table to .csv

..." "select ..." "select ..." "select ..." > query.csv Then, how to write the command in the correct way? Thanks! Nina ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] undefined reference

Greetings! Why I have got the message during installation postgrsql 7.0.2: utils/SUBSYS.o : In function 'load_file': utils/SUBSYS.o (text+0*3465d): undefined reference to 'dlclose' make: *** Error 1. There is the file dlfcn.h in /usr/include. Nina.