Re: [SQL] Table to Excel

hello use csv format - excel have to read this format without any format COPY tablename TO '...' CSV; regards Pavel Stehule 2009/3/26 Nicholas I : > Hi , > >  Does any one how to convert table to excel. > >  I just tried the COPY table_name to '/home/user/output.xls' using > delimiters ','; > >

Re: [SQL] Table to Excel

On Thu, 26 Mar 2009 08:04:25 +0100 Pavel Stehule wrote: > hello > > use csv format - excel have to read this format without any format > > COPY tablename TO '...' CSV; Another possibility that I use often is to set the output to HTML mode using: \H Then set to send query results to a file:

Re: [SQL] Table to Excel

2009/3/26 Josh Trutwin : > On Thu, 26 Mar 2009 08:04:25 +0100 > Pavel Stehule wrote: > >> hello >> >> use csv format - excel have to read this format without any format >> >> COPY tablename TO '...' CSV; > > Another possibility that I use often is to set the output to HTML > mode using: > > \H > >

Re: [SQL] Can we load all database objects in memory?

At 09:20 AM 3/26/2009, pgsql-sql-ow...@postgresql.org wrote: Message-Id: <587e5df3-5859-48de-93f9-f7b05c37e...@rvt.dds.nl> From: ries van Twisk To: DM In-Reply-To: Subject: Re: Can we load all database objects in memory? Date: Wed, 25 Mar 2009 15:07:21 -0500 References: X-Archive-Number: