[GENERAL] Error connecting to remote socket

2005-05-06 Thread Sunny 
Hi,


I am new to PosGreSql and have problem connecting to PostGreSql from a
machine with pslodbc driver. I don't know what is wrong but in my
simple code to connect to the database using ODBCConnection from the
server machine, it does not send out error message when I specify the
server as 'localhost' but when I set the server as 'Dbsvr' in the
connection string then it sent out ODBC error that it could not connect

to data source, could not connect ot remote socket. I would appreciate
if anyone can enlighten me. My postgresql.conf is below:


"


#-­--­

# FILE LOCATIONS
#-­--­



# The default values of these variables are driven from the -D command
line
# switch or PGDATA environment variable, represented here as ConfigDir.

# data_directory = 'ConfigDir'  # use data in another directory

# hba_file = 'ConfigDir/pg_hba.conf'# the host-based authentication

file
# ident_file = 'ConfigDir/pg_ident.conf'  # the IDENT configuration
file


# If external_pid_file is not explicitly set, no extra pid file is
written.
# external_pid_file = '(none)'  # write an extra pid file


#-­--­

# CONNECTIONS AND AUTHENTICATION
#-­--­



# - Connection Settings -


#listen_addresses = '*' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
port = 5432
max_connections = 100
# note: increasing max_connections costs about 500 bytes of
shared
# memory per connection slot, in addition to costs from
shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connection­s = 2
#unix_socket_directory = 'software-labs.net'
#unix_socket_group = 'software-labs.net'
#unix_socket_permissions = 0777 # octal
#rendezvous_name = ''   # defaults to the computer name
#tcpip_socket = true
# - Security & Authentication -


#authentication_timeout = 60# 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false 


" 
Thank you in advance, 


Sunny


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

[GENERAL] How to obtain the list of data table name only

2005-07-14 Thread Sunny 
Hi,

I am wondering if anyone can tell me how I can obtain only the list of
data table in postgresql without function and other ancillary tables. I
hope that I can add a tag that can filter only data table.

I am using the following SQL Statement:

"SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES"

I would appreciate if anyone can enligten me on how this can be
achieve. 

Sunny


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq