[GENERAL] File size consideration of file_fdw in PostgreSQL
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 queried, even we have where clause to narrow to a subset of rows , as the file_fdw doesn't have a server engine. Can you help with this, thanks. Xiaobo
Re: [GENERAL] How to list all schema names inside a PostgreSQL database through SQL
Thanks a lot. On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič ondrej.iva...@gmail.com wrote: Hi, On 15 November 2012 23:31, Xiaobo Gu guxiaobo1...@gmail.com wrote: How can I list all schema names inside a PostgreSQL database through SQL, especially thoese without any objects created inside it. Use -E psql's option: -E, --echo-hiddendisplay queries that internal commands generate then you get SQL query for each internal command. The second option is to use information_schema.schemata view (this is works across databases) -- Ondrej Ivanic (http://www.linkedin.com/in/ondrejivanic) -- 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] How to list all schema names inside a PostgreSQL database through SQL
Thanks a lot. On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič ondrej.iva...@gmail.com wrote: Hi, On 15 November 2012 23:31, Xiaobo Gu guxiaobo1...@gmail.com wrote: How can I list all schema names inside a PostgreSQL database through SQL, especially thoese without any objects created inside it. Use -E psql's option: -E, --echo-hiddendisplay queries that internal commands generate then you get SQL query for each internal command. The second option is to use information_schema.schemata view (this is works across databases) -- Ondrej Ivanic (http://www.linkedin.com/in/ondrejivanic) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to list all schema names inside a PostgreSQL database through SQL
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/mailpref/pgsql-general
Re: [GENERAL] question about \encoding option of psql
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 adrian.kla...@gmail.com wrote: On Wednesday, December 14, 2011 10:12:40 pm Xiaobo Gu wrote: Hi, I know \encoding is a meta command to set client encoding on psql prompt, but how can I set it inside the psql command line which will be called inside shell scripts, psql -h 192.168.72.7 -U gpadmin -w -d miner_demo -c\copy demo.store to 'd:\store.csv' with csv header How can I set the encoding for the export csv file? http://www.postgresql.org/docs/9.0/interactive/app-psql.html -c command --command command Specifies that psql is to execute one command string, command, and then exit. This is useful in shell scripts. Start-up files (psqlrc and ~/.psqlrc) are ignored with this option. command must be either a command string that is completely parsable by the server (i.e., it contains no psql-specific features), or a single backslash command. Thus you cannot mix SQL and psql meta-commands with this option. To achieve that, you could pipe the string into psql, like this: echo '\x \\ SELECT * FROM foo;' | psql. (\\ is the separator meta-command.) ^^^ If the command string contains multiple SQL commands, they are processed in a single transaction, unless there are explicit BEGIN/COMMIT commands included in the string to divide it into multiple transactions. This is different from the behavior when the same string is fed to psql's standard input. Regards, Xiaobo Gu -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] question about \encoding option of psql
Hi, I know \encoding is a meta command to set client encoding on psql prompt, but how can I set it inside the psql command line which will be called inside shell scripts, psql -h 192.168.72.7 -U gpadmin -w -d miner_demo -c\copy demo.store to 'd:\store.csv' with csv header 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
[GENERAL] postgresql-9.0.2-1-windows_x64 from EnterpriseDB can't install on Win 7 home basic 64 bit
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: Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed. Do you have any suggestion aout this, thanks. Xiaob Gu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Re: postgresql-9.0.2-1-windows_x64 from EnterpriseDB can't install on Win 7 home basic 64 bit
Hi, I have tried initdb manually, it failed: initdb -D D:\\Amber\\Program\\PostgreSQL\\9.0\\data --lc-messages=English -U postgres E UTF8 -A md5 and unfortunately initdb can't show the error messages probably, I think it is because of encoding, my notebook is in Simplified Chinese 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 guxiaobo1...@gmail.com wrote: 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: Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed. Do you have any suggestion aout this, thanks. Xiaob Gu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general