[ADMIN] How to extract table DDL from PGSQL database?

Title: How to extract table DDL from PGSQL database? How do I extract table or view DDL from a postgresql database?  I thought the PGAdmin tool would do this, but I haven't found the functionality there yet.  Looked at the system catalog tables, but didn't find everything I needed (version 7.1

[ADMIN] Need PGSQL ODBC Driver for Solaris

Title: Need PGSQL ODBC Driver for Solaris Can anyone tell me where to find a PostgreSQL ODBC driver for Solaris that I can use to share data with an Oracle database? Any suggestions or links to docs appreciated. Best regards, David B. Wagoner Database Administrator Arsenal Digital Soluti

[ADMIN] Share Data between PostgreSQL and Oracle

Title: Share Data between PostgreSQL and Oracle Anyone have experience doing this?  I would like to hear your tips and experiences. Here's our situation.  We have an Oracle DB on Sun Solaris 8 and a PostgreSQL DB on Linux (RH 7.3) that we need to share data between, specifically from Postgre

Re: [ADMIN] Need PGSQL ODBC Driver for Solaris

message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-----From

[ADMIN] Is there a NEW FEATURES section in docs?

Title: Is there a NEW FEATURES section in docs? Hi, I'm looking in the PostgreSQL online docs and do not see a section for New Features.  Is there such documentation that tells the new features by version number? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solut

[ADMIN] PostgreSQL Metadata

Title: PostgreSQL Metadata In Oracle, you can "select * from dictionary" to see the data dictionary table names and descriptions.  Is there something similar in PostgreSQL? Also, in Oracle you can store comments on tables and columns which provides valuable metadata.  Is this also possible in

Re: [ADMIN] PostgreSQL Metadata

mmediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: David Wagoner Sent: Thursday, October 30, 2003 1:30 PMTo: PGSQL List (E-mail)Subject: [ADMIN] PostgreSQL Metadata

[ADMIN] User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf

Title: User Login Authentication from Multiple IP Addresses (DHCP)? pg_hba.conf I've been reading the docs and FAQs for a method to setup pg_hba.conf to allow named users to connect using MD5/password authentication from any IP address.  For example, I have a Developer who would login using a

[ADMIN] Log to Syslog or rotatelogs? Advice Please

Postgres 7.3.9 on RH Linux... Setting up new production server- Is it better to send the postmaster log to Syslog or to rotatelogs? TIA, david ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] Re-initialize pg_hba.conf file?

Is there a way to have Postgres re-read the pg_hba.conf file while the database is up and running (i.e., no restarting)? Perhaps using SIGHUP? I added a user entry to the pg_hba.conf file and cannot bounce the database. thanks, david ---(end of broadcast)---

Re: [ADMIN] Re-initialize pg_hba.conf file?

Ah, my Sys. Admin. tells me this is the easiest way and it won't restart the database instance: kill -HUP postmaster_pid -david On Wed, 16 Mar 2005 15:40:35 +0100, Miroslav Åulc <[EMAIL PROTECTED]> wrote: > David Wagoner wrote: > > >Is there a way to have Postgres re-re