11,332 reputation
11845
bio website
location Munich
age
visits member for 3 years, 3 months
seen 5 mins ago

Jul
11
comment what is '#' in create table statement?
It always helps to read the manual: technet.microsoft.com/en-us/library/…
Jul
10
comment Creating unique constraint to be validated from input
@NanoJava Because to_char() is not marked as immutable (that's why you can't use it in an index definition) and you can not change a built-in function.
Jul
9
comment RAC, data guard, physical stand by and impdp
RAC and DataGuard are two different things. What exactly are you using?
Jul
9
comment How to increase the size of the tablespace in Postgresql?
A tablespace in Postgres doesn't have a (maximum) size. You just need to make sure there is enough space in the filesystem.
Jul
8
comment Postgresql service frozen and can restart properly
What's in the Postgres logfile?
Jul
8
comment Starting up postgres on Ubuntu for the first time
In addition to what Craig wrote: postgres doesn't have a parameter named --coordinator. Are you sure you are using (vanilla) Postgres? Are you using some kind of fork?
Jul
8
comment Adding an extra character to my column in select statement
SELECT id || 'A'.. is not PL/SQL, that's (standard) SQL. PL/SQL is only used in stored procedures (unlike SQL Server Oracle clearly distinguishes between SQL and procedural code).
Jul
8
comment Adding an extra character to my column in select statement
For "alphanumeric", varchar is the correct choice. But your example only shows numbers (no letters) and if you want to treat the values as numbers, they should be stored as such. If they are not numbers, then varchar is fine
Jul
8
comment Adding an extra character to my column in select statement
varchar and varchar2 are the same thing. Neither should be used to store numbers
Jul
8
comment Adding an extra character to my column in select statement
The question is tagged with sql which relates to standard SQL (not some deviation of it) and there + is the operator to add numbers and || is used for string concatenation.
Jul
7
comment date wise report and order by date
Added sql-server tag because of the non-standard [..] "quoting".
Jul
7
comment Oracle right outer join SELECT statement with a table
Your query is invalid. There is a dangling , before the from dba_tab_statistics clause. And the derived table doesn't have an alias so the join clause (on ...) won't work.
Jul
6
comment 60M+ InnoDB table simple query performance HELP
Create an index on pinc_codigo
Jul
5
comment Detailed optimal column order with large text and bytea
long text (or varchar) or bytea values are not stored inside the actual row.
Jul
5
comment Full table scan even after adding index
Please supply the execution plan and the full definition of the tables and indexes. Also which DBMS are you using?
Jul
5
comment Time series and gap filling
Not sure what you mean with "time series", but did you look into Postgres range data types? michael.otacoo.com/postgresql-2/…
Jul
4
comment PostgreSQL : inconsistent result when using WHERE clause on VIEW
An order by in a derived table (aka sub-select) doesn't make sense.
Jul
4
comment MS SQL - export tables to format compatible with PostgreSQL
I agree with Craig: you need to adjust your existing DDL scripts to Postgres syntax, create the tables, export from SQL Server as text (csv), then import. You might also want to try sqlserver2pg. I never used it, so I don't know if it works well: github.com/dalibo/sqlserver2pgsql
Jul
3
comment What is best strategy for backup on streaming replication(hot standby) environment
barman claims to be able to take a backup on the slave: docs.pgbarman.org/#concurrent_backup_and_backup_from_a_standby
Jul
3
comment How to insert into view through GUI in pgAdmin?
Did you check the DbExplorer's "Data" tab? You can even start the DbExplorer as a stand-alone window. So the users won't see a SQL editor or something similar. Only the list of tables/views. Click on the view, click on "Data", done.