To: [EMAIL PROTECTED]: Wed, 9 Apr 2008 08:50:44 -0500Subject: [ADMIN] How do i
get DDL of a Table from system catalog ?From: [EMAIL PROTECTED],How do i get
DDL of a Table from system catalog ?Purpose :1) i need to create an external
table on the basis of another table. create table ext
try starting psql with -E (would show queries psql does) option and \d+ the
table
On Tue, Apr 08, 2008 at 12:13:36PM +0200, Johann Spies wrote:
> I have got 8x720G disks in a hardware raid 5 setup. It is a Dell 2950
Thow away your RAID 5. It's a loser for this. Raid 1+0 is what you need.
> server. I am using an XFS-filesystem. I am not certain about the
On another note, I'
Hi,
How do i get DDL of a Table from system catalog ?
Purpose :
1) i need to create an external table on the basis of another table.
create table ext_table (like table_name); --> this doesnot work for external tables.
2) so i need to query catalog to get definition of the
Hello all
my struggle with the database continues (see earlier thread titled "too many
trigger records found for relation xyz").
Today, I created yet another to table to the same database. Everything went
ok, no errors or anything, but when I checked pg_tables -view I saw two
tables with the same
On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote:
> needs of others which can't be found because the script will generate
> them later. How can I make an orderer sql dump???
Use the custom format, use pg_restore to get the catalogue, and then edit
that catalogue to re-order
Hello.
I have a postgresql 8.2.4 server that ran low on disk space. I was
seeing messages
about some queries failing to run, and a hint about low disk space.
I noticed that the largest table in the database was returning 0 rows,
while other tables
just seemed to be missing some rows. One
Hi,
The setup in question includes PostGRESQL v8.2.4, Java based web servers and
MS.NET based web servers. Following is the fuzzy situation:
1. Our SQL queries run very fast using PSQL (both, from the server as
well as the client).
2. The Java app also retrieves the results very fast
