[GENERAL] postgresql-9.0.2-1-windows_x64 from EnterpriseDB can't install on Win 7 home basic 64 bit

2011-01-18 Thread Xiaobo Gu
Hi, I know you people have talked a lot about this, but until now I still can't install the newest release installed on my new Win7 Home basic 64 bit notebook, the user I run has administration previliege, and I have tried C and POSIX locale, neither works. The error message are the same: Probl

[GENERAL] Re: postgresql-9.0.2-1-windows_x64 from EnterpriseDB can't install on Win 7 home basic 64 bit

2011-01-18 Thread Xiaobo Gu
ese Locale, and I know EnterpriseDB does not support it now, do you have a road map to support this Locale in the near future? Thanks Xiaobo Gu On Tue, Jan 18, 2011 at 10:38 PM, Xiaobo Gu wrote: > Hi, >   I know you people have talked a lot about this, but until now I > still can'

[GENERAL] File size consideration of file_fdw in PostgreSQL

2013-06-22 Thread Xiaobo Gu
Hi, We have very large files in size will be created as external tables in PostgreSQL via file_fdw, we have the following considerations: 1. Can file_fdw handle files with size large than the size of RAM in the server. 2. Will file_fdw scan the full file every time when the external table is queri

[GENERAL] How to list all schema names inside a PostgreSQL database through SQL

2012-11-15 Thread Xiaobo Gu
Hi, How can I list all schema names inside a PostgreSQL database through SQL, especially thoese without any objects created inside it. Regards, Xiaobo Gu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] How to list all schema names inside a PostgreSQL database through SQL

2012-11-18 Thread Xiaobo Gu
Thanks a lot. On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič wrote: > Hi, > > On 15 November 2012 23:31, Xiaobo Gu wrote: >> How can I list all schema names inside a PostgreSQL database through >> SQL, especially thoese without any objects created inside it. > > U

Re: [GENERAL] How to list all schema names inside a PostgreSQL database through SQL

2012-11-18 Thread Xiaobo Gu
Thanks a lot. On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič wrote: > Hi, > > On 15 November 2012 23:31, Xiaobo Gu wrote: >> How can I list all schema names inside a PostgreSQL database through >> SQL, especially thoese without any objects created inside it. > > U

[GENERAL] question about \encoding option of psql

2011-12-14 Thread Xiaobo Gu
How can I set the encoding for the export csv file? Regards, Xiaobo Gu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] question about \encoding option of psql

2011-12-15 Thread Xiaobo Gu
Hi Adrian, I am on the Windows platform, how should I paste the command line. Regards, Xiaobo Gu On Thu, Dec 15, 2011 at 10:44 PM, Adrian Klaver wrote: > On Wednesday, December 14, 2011 10:12:40 pm Xiaobo Gu wrote: >> Hi, >> >> I know \encoding is a meta command to s